Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007

    Unanswered: Improving Database Perfromance

    Hi All

    I Have performance issues with the Database. I have an existing database which has indexes created.

    But when ever i run some queries, it takes quite long time to get the results. I have seen the access path of the queries and made sure that , the tables are accessed using indexes path only. I created additional indexes also when needed.

    Now , i would like to know , how i can improve my Database performance that my queries runs faster.

    Is there any thing called as "Query Cahing"
    If yes , how i can implement that for my Database.

    Thanks in Anticipation

  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    First you may want to run your queries through the DB2 Design Advisor. Additionally, run the DB2 Configuration Advisor to get a good baseline configuration for your system.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3

Posting Permissions

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