Database (SQL) Techniques - book notes
- Queries:
- Reduce amount of group-by columns
- Fill table with test data
- Nullable columns
- Prevent division by zero
- Sort order with nullable columns
- Ordering & pagination
- Efficient pagination
- Database locks
- Common table expressions
- First of many similar rows
- Multiple aggregates
- Row limits and ties
- Fast row count estimates
- Date-based statistical queries
- Table joins - for-each loops