Chapter 1: Tuning the Database

In This Chapter

arrow Examining the work to be done

arrow Contemplating physical design considerations

arrow Choosing and clustering indexes

arrow Co-clustering two relations

arrow Indexing on multiple attributes

arrow Tuning indexes, queries, and transactions

arrow Query tuning in a high-concurrency environment

arrow Benchmarking

arrow Keeping user interactions separate from transactions

arrow Holding down traffic between application and server

Creating a precompiled list of frequently used queries

The word tuning ...

Get SQL All-in-One For Dummies®, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.