to-be-or-not-to-be.sql

create table test
as
select id, random() > 0.5 as to_be
from generate_series(1, 10000000) as id;

CREATE INDEX IF NOT EXISTS idx_1
    ON test (id)
    WHERE to_be = true;

CREATE INDEX IF NOT EXISTS idx_2
    ON test (id)
    WHERE to_be = false;

-- Without to_be or not to_be
explain
select *
from test
where id = 1;

-- With to_be or not to_be
explain
select *
from test
where id = 1 and (to_be or not to_be);