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