forgot about something else. this is the inner loop in a join that has an aggregate sort. Im willing to bet that the CBO needs to search every record in that table, if that is the case, then an index is slower and will not be chosen.

doh... forgot that one too.

Oracle LazyDBA home page