when I am generating explain plan for one of my queries, I have observed the note "rule based optimizer used (consider using cbo)".
what made Oracle to user rule based optimizer? any clue will be much appreciated.
Database is 10.2.0.4
If i generate the plan for same query with some hint then it is using cbo which is expected.