I have two databases on one the index I like is getting used on the other it uses a different index.
and record_date > sysdate - 10
order by upper(name)
I have a FBI on name and another index on record_date.
In one database
(lets call it Database1) the query uses the date index
(on the other Database2) it uses the FBI.
Infact it seems to like the FBI on the second database most of the time ; even when the query changes to have a different filter condition that is indexed.
The dataset is identical
Both database were analyzed.
Both have same init parameters
Database 1 is on 126.96.36.199
Database 2 on 188.8.131.52