index is there but Oracle doesn't pick up the index

[DaPi]

a) Are the "Est. Rows" about right?
and
b) How selective will "level=5" be?
(I'm assuming level is in the table beam.shapefile.)

If the answer to (a) is "yes", then the answer to (b) is "not very". So the full table scan will be the best option.