Hi everybody,
What are the steps in SQL query tuning..wrt to explain plan,TKPROF,ANALYZE?.
say..I have a big query.i will give it to explain plan..some result data is inserted in to plan table. How do u interpret the data in the plan table and improve the query?.
Suresh.H.T