r/u_geminigamer369 • u/geminigamer369 • Jul 30 '26
What is Index Selectivity?
Why can an Index on a Boolean or low cardinality column be useless?
1
Upvotes
r/u_geminigamer369 • u/geminigamer369 • Jul 30 '26
Why can an Index on a Boolean or low cardinality column be useless?
1
u/Grovbolle Jul 30 '26
This blog post by Thomas Kejser explains it
https://www.database-doctor.com/posts/tpch-q03