We have created a view in Toad which contains approx. 1.6 million rows
I have successfully connected to the Oracle View Table, created a Power Query View / Power Pivot in Excel however it takes forever for the data to load and it keeps on bombing out. Does anyone have any suggestions in dealing with large volumes of data…our goal was to have the end users connect to the view using excel and then filter using pivot tables.
Thanks in advance