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
Neha

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.

Also take a look on this pages:
http://www.ibm.com/developerworks/db...107anshum.html
http://www.ibm.com/developerworks/db...-0404mcarthur/