Try to set your session to RBO and try again:
SQL> Alter session set optimizer_mode = rule;
SQL> explain plan for YOUR_QUERY;
If work by index now try to delete statistics.
|
Results 1 to 7 of 7
Thread: Full Table ScanThreaded View
|
Click Here to Expand Forum to Full Width |