Is there a (shorter) expression we can use to do the following?
... WHERE parent_id = '' OR parent_id IS NULL
... WHERE parent_id <> '' OR parent_id IS NOT NULL
Basically empty string and NULL mean both NULL for us ? (historical reasons)
The index definition containing this field we would like to to hit is:
Is the query somehow problematic with regards to the index definition?