-
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
-
go tahiti.oracle.com, read performance design and tuning guide chapter 1 to 11
-
-
Amar, shhhhhh.... we are training him!
-
Originally posted by DaPi
Amar, shhhhhh.... we are training him!
ok, i was not here.
Amar
"There is a difference between knowing the path and walking the path."
-
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
Amar
"There is a difference between knowing the path and walking the path."
-
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.
bye,
srikrishna DBA 9iocp
-
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.
bye,
srikrishna DBA 9iocp
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|