Explain Plan

Hi friends

can some body tell me what does an explain plan command do?
and how to use it.

Using EXPLAIN PLAN will tell you how your query will be executed. Check out:
http://technet.oracle.com/docs/produ...1d.htm#2061798

Thanks jeff