Originally posted by sureshht
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


query from plan table these columns that is
object_name,options,operations.Then it will give some what clear
pciture.Other wise put set autotrace on where you have plan_table.

bye,
srikrishna DBA 9iocp