Home > IT Answers > DataCenter > DB2: Optimizer not using any indexes
AS400 - Ask the Expert
485 pts.
 DB2: Optimizer not using any indexes
AIX, DB2, DB2 8.x
I have DB2 version 8.2 installed in AIX one thing I am seeing is strange that optimizer not using any indexes. In any simple join index are not being used. Is there any parameter which needs to be set up?

Software/Hardware used:
ASKED: July 1, 2008  5:15 PM
UPDATED: August 14, 2008  9:36 PM
RELATED QUESTIONS
Answer Wiki:
The optimizer relies on accurate statistics for your data. If you didn't set up automatic statistics (give a look at <a href="http://www.ibm.com/developerworks/db2/library/techarticle/dm-0706tang/index.html">http://www.ibm.com/developerworks/db2/library/techarticle/dm-0706tang/index.html</a>) you must run the utility RUNSTATS to populate your metadata (catalog) with them. This, of course, assumes that the indices are on the keys(columns) that you are joining on or searching on.
Last Wiki Answer Submitted:  August 14, 2008  9:36 pm  by  RodneyKrick   265 pts.
All Answer Wiki Contributors:  RodneyKrick   265 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _