When a single table query specifies an ordered analytical function on columns that are also defined for a single table compressed join index, the Optimizer does not select the join index to process the query.
When a single table query specifies an ordered analytical function on columns that are also defined for a single table compressed join index, the Optimizer does not select the join index to process the query.