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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!