I am very new to Oracle and am having issues with Oracles cost based optimizer.
To be honest from what I am seeing it is horrible.
We are having to use way to many hints such a rule and index in order to get queries to run in a decent amount of time.
I have updated the stats on all tables and indexes yet the optimizes frequently does not use indexes that would be ideal for the query.
I am sure I have probably missed something due to my lack of experiance with oracle so any tips would be a great help.
Things like config parameters, recommended ways to generate histagrams and other tips and tricks be great.
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!