Forum Stats

  • 3,769,349 Users
  • 2,252,952 Discussions
  • 7,874,993 Comments

Discussions

index hint not being used

managed BEAN
managed BEAN Member Posts: 948 Silver Badge

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

Tagged:

Best Answer

Answers