The art of SQL /
Stephane Faroult, with Peter Robson.
- Sebastopol, CA : O'Reilly, c2006.
- xvi, 349 p. : ill. ; 24 cm.
- Theory in practice .
- Theory in practice. .
Includes index.
1. Laying plans : designing databases for performance -- 2. Waging war : accessing databases efficiently -- 3. Tactical dispositions : indexing -- 4. Maneuvering : thinking SQL statements -- 5. Terrain : understanding physical implementation -- 6. The nine situations : recognizing class SQL patterns -- 7. Variations in tactics : dealing with hierarchial data -- 8. Weaknesses and strengths : recognizing and handling difficult cases -- 9. Multiple fronts : tackling concurrency -- 10. Assembly of forces : coping with large volumes of data -- 11. Stratagems : trying to salvage response times -- 12. Employment of spies : monitoring performance.