I have a particularly intense query. In SQLDeveloper it takes about 25 mins to return 50 rows. There are only just over 500 rows, but it’s taking so long with Toad’s default return of 500 rows that I cancelled the query.
Is there a way to reduce the number of rows returned. I want TOAD to do the actual exporting of the data. I find SQLDeveloper very temperamental.