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!

index hint not being used

managed BEANJul 5 2021

Hello everyone,

I am providing a hint on a query:
select CONTENT6 /*+ index(PARAMETERS PARAMS_IDX) */
from PARAMETERS
where PROGNAME='Global'
and PROCNAME='Other'
and VARNAME='Generic_cfg_local'
and (WORKSTATIONKY='140' or WORKSTATIONKY is NULL)
and 1=1;

But for some reason it´s not working on another schema (the one on the rigth) , and i do not knnow why, can you please help me out:

I realize optimizer is choosing another index rather than the one i sugested (but is used on left schema), but i want to use it (in that case i could compare explain plan for the same schema, also).
Thanks in advance