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.