Chapter 1: Tuning the Database
In This Chapter
Examining the work to be done
Contemplating physical design considerations
Choosing and clustering indexes
Co-clustering two relations
Indexing on multiple attributes
Tuning indexes, queries, and transactions
Query tuning in a high-concurrency environment
Benchmarking
Keeping user interactions separate from transactions
Holding down traffic between application and server
Creating a precompiled list of frequently used queries
The word tuning ...