I am testing query run times in TDA, as we are hoping to migrate from Toad for Oracle to TDA, and want to make sure our query times are not negatively impacted.
One of my tests is a simple select query that returns a large amount of data
It has almost 50 columns and returns approximately 730,000 rows. When I run it in Toad for Oracle, it takes about 15 seconds to pull back all the rows. In TDA, it’s over a minute.
Does any one have any suggestions to improve the processing time in TDA to come closer to Toad for Oracle? Or is it just the nature of the tool?