Oracle didn't use index

[marist89]

Originally posted by ashley75
Thanks all but my query is not working now on explain plan.

Please advise the below query

select /*+ grid_master_lvl_idx (grid_master) */
from grid_master
where grid_lvl=2 and grid_priority=1

it is telling me that missing expression

You're syntax is wrong:

select /*+index(gm grid_master_lvl_idx) */
from grid_master gm
where gm.grid_lvl=2 
and gm.grid_priority=1