Re: Query execution time message
I'd love an official answer to this question too.
I get some very odd behavior from these two little numbers. For instance, SELECT 10,000 records, and you get one result, but then SELECT COUNT(*) from that same dataset, and the numbers reverse. If the paren number is the processing time, then you'd expect it to be roughly the same whether you return the records to the client or simply count them.
The TOTAL of the two numbers, at least, seems to roughly equal the time it takes to complete the whole shebang, so I guess that's what we really care about: Total Time = a + b.
Subject
Written By
Posted
November 12, 2005 08:37AM
February 24, 2006 06:51AM
February 08, 2007 08:54PM
February 26, 2007 11:34PM
Re: Query execution time message
November 08, 2007 01:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.