when I am generating explain plan for one of my queries, I have observed the note "rule based optimizer used (consider using cbo)".

optimizer_mode=choose

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.

Thanks,