Re: Optimize query

1 There is nothing, and really nothing wrong with an index range scan
2 Please provide a link or a quote where you read this nonsense on
analytical functions
3 Without any *specific* information (exact Oracle version, explain
plan output, exact index defintions)
nobody can help you.

--
Sybrand Bakker
Senior Oracle DBA

.