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).


Post a Comment

<< Home