#10-17: Common Sense SQL Rules
10. Simpler is better, but complex SQL can be efficient
- In general, let SQL do the work, not the program
11. Retrieve the absolute minimum # of rows required
12. Retrieve only those columns required - never more
13. Always provide join predicates (i.e. no Cartesian products)
14. Favor Stage 1 predicates
15. Favor indexable predicates
16. Avoid tablespace scans (for large tables)
17. Document everything - especially shortcuts!