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