3 ms·
Yes, it is because it leaves you with half the table the scan while adding the overhead of doing an index scan. And of you have a biased distribution you probab
by jeltz 4y ago
Yes, it is because it leaves you with half the table the scan while adding the overhead of doing an index scan. And of you have a biased distribution you probably want a partial index since those are smaller.
- xwdv 4y agoNo, it’s rarely half the table, most bool columns are biased to one value.