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:
"I pledge to stop eating sharks fin soup and will not do so under any circumstances."