I'm using postgres db. I want to display records with nulls before the rest of results. Is it good practice to use NULLS FIRST on large amount of data?
... ORDER BY last_updated NULLS FIRST
Is there any better solution?
I'm using postgres db. I want to display records with nulls before the rest of results. Is it good practice to use NULLS FIRST on large amount of data?
... ORDER BY last_updated NULLS FIRST
Is there any better solution?
You can create an index to support that
order by
: