| Subject | Ordering with nulls first and index usage |
|---|---|
| Author | Marcin Bury |
| Post date | 2012-11-30T12:34:04Z |
Hello All
When I specify ORDER BY A_COLUMN DESC NULLS FIRST, the descending index
created on this column is not used and I get 'natural' in plan.
Is there a possibility to use some index when 'nulls first' is specified .
TIA
Marcin
When I specify ORDER BY A_COLUMN DESC NULLS FIRST, the descending index
created on this column is not used and I get 'natural' in plan.
Is there a possibility to use some index when 'nulls first' is specified .
TIA
Marcin