Categories
4 pages
Anti-Patterns
Covering Index Traps: When Adding One Column Breaks Your Query
God Tables: 150 Columns and the Quiet Cost of 'Just Add a Column'
Non-SARGable Predicates: How a Function in WHERE Kills Your Index
Random UUIDs as Primary Keys: The B-Tree Penalty