If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Query tuning

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

Re: Query tuning

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.

Re: Re: Query tuning

Originally posted by srikrishna 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
and execute that query then it gives you all statistics of resources
as well as joining tables.