Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008

    Post Unanswered: Identify Bad SQL statement

    Hi All,

    I am new DB2DBA and I have a general question to Pro DBA's. Suppose one of the developer complained about their set of SQL statements are not performing fast ,it's taking to long to get the result. How do identify which SQL statement needs to be tuned ?

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    I'd start by asking one of the developers to run their SQL statements one by one and tell me which one he thinks is the culprit, why is it that he thinks so, and what he thinks is the acceptable performance.
    "It does not work" is not a valid problem statement.

Posting Permissions

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