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

Thread: SQL Performance

  1. #1
    Join Date
    May 2006
    Posts
    2

    SQL Performance

    Hi Greetings,
    When users start complaining that a specific SQL command is working at slower pace, what are the sequence of steps to be taken to locate and rectify the defect??

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    thanks for the feedback

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    What is slow slow? For all you know their pcs are slow!

    Run a profiler tool
    pick that query
    run stats pack and see/identify the degeneration of the sql query over time
    take the query and whack it to run in some similar test/dev environment
    try to tune the query and see if you can
    ..This is no where close to any sequence. Pick up the perf manual from oracle.com and read it too
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  4. #4
    Join Date
    May 2006
    Posts
    2
    Thanks Mr Tarry.

  5. #5
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349

    Arrow

    When somebody is saying sql query is slow. u can follow these steps.
    Take the trace of the sql and verify the xplain plan.
    Queries can be tuned by checking if there is better path to follow, like is it picking the good index or no index at all, some times it can be tuned by rewriting the query.
    http://www.perf-engg.com
    A performance engineering forum

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