medium10 pts · first answer countsdatabasesindexes

Index on a true/false column

A users table has 10 million rows, and is_active is true for 95% of them. Will an index on is_active speed up `WHERE is_active = true`?

A.Unlikely; a table scan is cheaper for 95% of rowsB.Yes, every column in a WHERE should be indexedC.Yes, booleans make the fastest indexesD.No, booleans can never be indexed

Discussion 0

Join free to post in the discussion.

Index on a true/false column

Discussion 0

Related questions