Chapter 2 Guidelines on Logical and Physical Design

Table of Contents

Normalization Issues
Including Calculated Data in Tables
B-Tree Index Design
Clustering Indexes
Choosing Appropriate Index Types
Authorization Design
Using a Duplicate Database

Creating DBEFileSets
Creating DBEFiles
Creating Tables
Initial Table Loads
Unloading Data
Unloading and Reloading to Remove Indirect Rows
Unloading and Reloading to Remove Overflow Pages
Tips on Deletions from Tables

This chapter shows how to adjust the logical and physical design of your databases for best performance. Additional general information on this subject appears in the "Logical Design" and "Physical Design" chapters of the ALLBASE/SQL Database Administration Guide. Refer also to the "Guidelines on System Administration" chapter below.

Chapter 2 Guidelines on Logical and Physical Design

Technical documentation

» Table of Contents

» Index