Table of Contents
Physical Database Design and Tuning
Overview
Choice of Indexes
Issues to Consider in Index Selection
Issues in Index Selection (Contd.)
Examples of Clustering
Clustering and Joins
Co-Clustering Relations
Tuning the Conceptual Schema
Horizontal Decompositions
Horizontal Decompositions (Contd.)
Masking Conceptual Schema Changes
Tuning Queries and Views
More Guidelines for Query Tuning
Guidelines for Query Tuning (Contd.)
The Notorious COUNT “Bug”
Summary
Summary (Contd.)
Summary (Contd.)
State of the Art, physical design
|