Hi;
Probably your Query runs better in RULE-Based Mode;
So access the table with /*+RULE*/-Hint
In our production-Environment very often the hint increases performance due to the CBO likes to scan tables full in some situations for ecample with the OR or NOT -Operator or <>-Operator.

Orca