Re: **Performance of queries

I know that but he asked for "how fast the query was"

I expected he meant clock time, IOW, I tried to answer the question he asked.

EXPLAIN PLAN is a good tool to know, however, it does not actually execute the query, so you can not get timing information from it. The third tool of course is SET AUTOTRACE, which does execute the query.

I have used all of these tools and tricks to evaluate SQL code and improve it.

David Ng wrote in message <371CA665.48310E08_at_attmysite.com>...
>Explain Plan tells you the actually execution plan of the SQL. That is
>the common way to evaluate if the SQL performs.
>
>For details, please refer to Oracle document
>
>Ed Prochak wrote:
>
>> Look in your documentation and check
>>
>> SET TIMING
>>
>> I also usually have it display the current time also. That's another one
>>
>> SET TIME
>>
>> Haruka Suko wrote in message <7fgnq9$b8c$2_at_bgtnsc02.worldnet.att.net>...
>> >Hello!
>> >I would like to know the performance of the query(how fast the query was
>> >executed, etc).
>> >Do I need to use tkprof? If anyone can tell me how to use it, I really
>> >appreciate it.
>> >Or, is there any way to measure the performance of the query without
>> tkprof?
>> >Thank you so much!
>> >
>> >Haruka Suko
>> >haruka-suko_at_worldnet.att.net
>> >
>> >
>> >
>
Received on Wed Apr 21 1999 - 21:03:14 CEST