When an ordered analytical function is specified on columns that are also defined for a compressed hash index, the Optimizer does not select the hash index to process the query.
When an ordered analytical function is specified on columns that are also defined for a compressed hash index, the Optimizer does not select the hash index to process the query.