On Thursday, August 3, 2023, [Quipsy] Markus Karg <karg(at)quipsy(dot)de> wrote:
> EXPLAIN SELECT column FROM Table WHERE column = X AND column = Y
>
>
>
> …says that PostgreSQL actually wants to perform a Scan!
>
>
>
> I wonder why squandering any resources into a Scan here
>
Mostly because no one wants to volunteer to write code to deal with poorly
written queries, nor, more technically, expend compute resources looking
for situations that should not happen.
David J.