Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I'm trying to develop a on type search component on Account object and stumbled upon using this query
SELECT Name
FROM Account
ORDER BY Name DESC NULLS LAST
As you can see from the above query I'm ordering by Name field. My question is Name(Indexed) field on Account is always required so does it have any negative effects doing DESC NULLS LAST if the volume of Account records in my org is higher say 1 million.
Assuming you're filtering your query, the NULLS (FIRST|LAST) operator won't have any negative side effects. Just remember to filter/limit your query, and you'll be fine.
