Is that Index used in the execution path?

Analyze both tables. Run explain plan.
Post the outout of explain plan.