Re: **Performance of queries

[Quoted] 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 Tue Apr 20 1999 - 18:08:05 CEST