Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    78

    Unanswered: best for sql tunning

    Hai

    Which one is best for sql tunning either stats pack or tkprof and explain plan.If use statspack why.

    Thanks in advance
    mohan

  2. #2
    Join Date
    Apr 2002
    Location
    beijing,china
    Posts
    20
    explain plan !
    status pack is use for instance level tuning.
    db2oracle

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    You are tuning SQL query by modifying the parameters or hints so you can get the best excution plan. You should be able to see the excution plan, to see the SQL execution statistics and that's what tkprof and explain plan are giving you.

    Stick with them if you are tuning SQL queries.

    Hope that helps,

    clio_usa
    OCP - DBA

Posting Permissions

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