An index that will not be used
A students table of 2,000,000 rows has an is_active boolean, and 96%
of rows are active. An index is created on it, and the optimiser ignores it for
WHERE is_active = true.
Why is that the right decision?
A students table of 2,000,000 rows has an is_active boolean, and 96%
of rows are active. An index is created on it, and the optimiser ignores it for
WHERE is_active = true.
Why is that the right decision?