Why does PostgreSQL use a sequential scan instead of a bitmap index scan with my composite index?
I have a table called orders_table
in postgres and I am creating composite index using two columns order_id
and customer_id
.
Why does PostgreSQL use a sequential scan instead of a bitmap index scan with my composite index?
I have a table called orders_table
in postgres and I am creating composite index using two columns order_id
and customer_id
.