Environment - Windows 7 32 Bit
Oracle 11g Release 11.2.0.2.0
Toad 11.0.0.116
When I run a query (using the Execute as a Script) in the Editor screen that returns more than 100 rows Toad takes an very long time to return rows.
tblatatimecard has 25841 rows and 27 columns (about 50% null)
select * from tblatatimecard
where rownum < 11
214 msces to run - less than a second to display results
select * from tblatatimecard
where rownum < 101
447 msecs - 5 seconds to display results
select * from tblatatimecard
where rownum < 200
735 msecs - 1 min 23 seconds to display results
select * from tblatatimecard
where rownum < 500
Canceled after 3.5 minutes
When I run the exact same queries using the Execute/compile statement at caret, the grid displays almost instantaneously. Also, if I do the same with Oracle’s SQL Developer I get almost instantaneously results.
My question is: Is there any reason why the big discrepancy in performance between the two ways of executing a query? Are there any settings that will improve performance?
Thanks
Rick Anderson