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.