easy5 pts · first answer countsindexingquery-tuning
Index on a yes/no column
A 50 lakh row orders table has an is_active column where about half the rows are true and half are false. A developer adds a B-tree index on is_active alone. Why does the planner usually ignore it for WHERE is_active = true?
Discussion 0
Join free to post in the discussion.
Related questions
- When a B-tree index helpsDatabase Administrator
- Finding slow MySQL queriesDatabase Administrator
- How InnoDB stores table rowsDatabase Administrator
- What an InnoDB secondary index points toDatabase Administrator
- LIKE with a leading %Database Administrator
- What a hash index supportsDatabase Administrator
- Cost of extra indexes on insertsDatabase Administrator
- EXPLAIN versus EXPLAIN ANALYZEDatabase Administrator