On Fri, Nov 7, 2025 at 6:16 AM Michael Christofides
wrote:
> Thank you for the incredibly helpful (and fast) replies Peter.
You're welcome.
> Nice idea. Once it sunk in, I realised I could try the explicit "AND
> boolean_field IN (true, false)" and got it down to 2 index searches:
>
> EXPLAIN (
Thank you for the incredibly helpful (and fast) replies Peter.
> Attached is its output when I run your test query. The issue here is
that skip scan thinks that there are 4 distinct skip array values that
it must use:
1. SK_BT_MINVAL
2. false
3. true
4. SK_ISNULL
This output in particul
