forgot about one other thing... do you have any nulls in that column? if you do, no index.

you can get around that by adding

where col is not null

forgot about that one.

Oracle LazyDBA home page