Is possible to create a index with "nulls first" ?

15 views
Skip to first unread message

Roberto Vieweg

unread,
Feb 11, 2021, 7:51:38 AMFeb 11
to firebird-support
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?
Reply all
Reply to author
Forward
0 new messages