could someone tell me why it's still doing a full table scan on GRID_MASTER ??? I have index on GRID_LVL and here is the the query.



SELECT /*+ INDEX(GRID_MASTER A GRID_MASTER_LVL_IDX)*/ a.grid_lvl2_code, b.grid_lvl3_code
FROM grid_county_centroid B,grid_master A
WHERE sdo_relate(B.centroid,A.sob_geometry, 'mask=anyinteract querytype=join') = 'TRUE'
and a.grid_lvl = 2;

for some reason, it still didn't force to user the index, maybe my hint is not right.

Please advise