Is possible to create a index with "nulls first" ?
I created a index like this:
CREATE DESCENDING INDEX IDX_UPDATE_WORK ON UPDATE_WORK (END_MOMENT);
But when I run the query the PLAN becomes NATURAL
select * from UPDATE_WORK a order by a.END_MOMENT desc nulls first
If I remove the "nulls first" the PLAN uses my index, but this isn't my desired behavior.
How can I solve this?