DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Query tuning

  1. #1
    Join Date
    Mar 2003
    Posts
    20

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    go tahiti.oracle.com, read performance design and tuning guide chapter 1 to 11

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Amar, shhhhhh.... we are training him!

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    May 2003
    Location
    Hyderabad
    Posts
    3

    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

  9. #9
    Join Date
    May 2003
    Location
    Hyderabad
    Posts
    3

    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

  10. #10
    Join Date
    May 2003
    Location
    Hyderabad
    Posts
    3

    Re: Re: Query tuning

    nothing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width