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

Thread: sql tuning

  1. #1
    Join Date
    Aug 2007
    Posts
    14

    sql tuning

    how can i solved the problem regarding the query is very slow. the same query was fine one day ago.

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    u shud read docs
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Aug 2007
    Posts
    14
    Thanks for the best suggestion.

  4. #4
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    You have not posted the sql explain plan anything.
    Anyway could be due to index deletion, gather stats anything..
    http://www.perf-engg.com
    A performance engineering forum

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    you will get valuable suggestion only when u have done your ground work proper.. post all necessary details.. then u can expect somethings, else the ones like above & ofcourse with suggestion to read the sticky post (on top of this forum).
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    please paste the query, explain plan, + the details like number of records, how the table is partitioned (if).

    it will be easy for others to help.
    Cheers!
    OraKid.

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