please help me with this query:
select grid_name, grid_lvl2_code
From spatial.grid_master
Where grid_lvl = 2 and
grid_priority = 1
I look at the explain plan table and notice that it does a full tablescan, I have an index on the column grid_lvl.
Please advive what I need to do.
Thanks