Tag Archives: clustering

Optimizing Database Performance, part 5: Database Reorganization

Portions of this tip were excerpted from my book Database administration: The complete guide to DBA practices and procedures (2nd edition). The first , second , third, and fourth parts of this series are also available. Today’s topic is reorganization. Relational technology and … Continue reading

Posted in DBA | Tagged , , , | 5 Comments

Optimizing Database Performance, part 2: Denormalization and Clustering

In Part 1 of our series introducing database performance topics and considerations we tackled the issues of partitioning data and creating indexes. In Part 2, today, we will introduce the topic of denormalization and clustering. Denormalization Another way to optimize the … Continue reading

Posted in DBA | Tagged , , , , | 6 Comments