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
Keeping user interactions separate from transactions
Holding down traffic between application and server
Creating a precompiled list of frequently used queries
The word tuning is generally ...
Get SQL All-in-One For Dummies, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
