What I'm trying to pin down is how accurate the execution time displayed in TOAD is. For some complex queries, the time displayed may be 1 second. If I trace the query using TKPROF it reports about 4 seconds. I assume TOAD is populating the grid as fast as it can and continuing to run the query in the background ?

ANSWER:  This is the amount of time it takes for execution to return to the Sql Editor after sending the statement to Oracle. This will also include any time it takes to fetch the initial 25 rows. So, this is the amount of time it takes IN TOAD to execute the statement and is not meant to correspond to TKProf.

About the Author

Steve Hilker

Steve Hilker was a Product Manager for Quest Software. Steve has over 35 years technical experience spanning application development, system administration, database management and various management positions at several software companies. Steve was the founder of RevealNet, best known for its desktop knowledge bases and unique database tools such as PL/Formatter. RevealNet was acquired by Quest Software in 2001. He's had the pleasure of being the product manager for many of Quest's database tools.