Re: Query plan for "id IS NULL" on PK

[Rob Sargent <robjsargent@xxxxxxxxx>]

On 2/14/23 15:30, David G. Johnston wrote:

On Tue, Feb 14, 2023 at 3:25 PM Rob Sargent <robjsargent@xxxxxxxxx> wrote:

When will id be null in a primary key?

The OP seems to be aware of this...

"We cannot change the query being executed. Is there any way we can make the query planner ignore `OR (id IS NULL)` (as that will never be the case for the PK) and use both `id` clauses in the index condition?"

David J.

    Yes, agreed.
      But if the query is supposed to be generic and re-used in a
      situation where id could be null, wouldn't the null id records be
      fetched every time?