Physical Database Design and Tuning

11/1/99


Click here to start


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

Email: vandenbe@cs.washington.edu

Home Page: http://www.cs.washington.edu/education/courses/594/99au/

Download presentation source