SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why won't this simple SQL USE the index?

user12240205Jan 21 2016 — edited Feb 3 2016

I am baffled by this issue I am facing:

This SQL:

SELECT * FROM pr4_rule d WHERE d.pyRuleSet = '1' AND d.pyRuleSetVersion = '2' AND d.pxObjClass = '3';

does NOT use the INDEX, according to the EXPLAIN PLAN.

I want it to use the index.

Why is the plan not using it?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 1 2016

Added on Jan 21 2016

28 comments

5,086 views