Data Base Tips/ SQL Commands...

Friday, August 05, 2005

Performace / Set Timing On


We  can measure the performance of different queries by setting TIMING:

 

Set Timing on

 

Now, each time we run a query, we will see the time it took Oracle to solve it at the end. This is especially good when we are debating on which way is faster (e.g., a join or a sub query).

0 Comments:

Post a Comment

<< Home