Printable View
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
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 :DQuote:
Originally posted by pando
go tahiti.oracle.com, read performance design and tuning guide chapter 1 to 11
Amar, shhhhhh.... we are training him!
ok, i was not here.Quote:
Originally posted by DaPi
Amar, shhhhhh.... we are training him!
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
I sincerely pray that you always sleep well :) so that we can see the softer side of Pando ;)
Quote:
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
Quote:
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
nothing