Query tuning

[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

[pando]

go tahiti.oracle.com, read performance design and tuning guide chapter 1 to 11

[adewri]

Originally posted by pando
go tahiti.oracle.com, read performance design and tuning guide chapter 1 to 11

How come Pando is not using the RTFM. Are you not well

[DaPi]

Amar, shhhhhh.... we are training him!

[adewri]

Originally posted by DaPi
Amar, shhhhhh.... we are training him!

ok, i was not here.

[pando]

oh! coz I just remmebered the chapters so I am doing a favour saying where you can find it, or probably I slept well yesterday night hhehehehehhee

[adewri]

I sincerely pray that you always sleep well so that we can see the softer side of Pando

[srikrishna]

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

[srikrishna]

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.

bye,
srikrishna DBA 9iocp

[srikrishna]

nothing