Home | Previous Page | Next Page

Managing Tables and Indexes

In This Chapter

Planning and Managing Tables

Choosing Table Types

Using STANDARD Tables

Using RAW Tables

Using STATIC Tables

Using OPERATIONAL Tables

Using Temporary Tables

Specifying a Table Lock Mode

Managing Disk Space for Tables

Choosing the Initial and Next Extent Sizes

Specifying the Extent Size for System-Managed Temporary Tables

Limiting the Number of Extents for a Table

Reducing Extent Interleaving

Reclaiming Unused Extent Space

Updating and Changing Tables

Loading and Unloading Table Data

Attaching or Detaching Fragments

Altering a Table Definition

Planning and Managing Indexes

Evaluating Index Costs

Disk-Space Costs

Update-Time and I/O Costs

Avoid Globally Detached Indexes

Choosing a Clustering Index

Specifying the Percent of Index Page Space for Expansion

Specifying the Lock Mode for Indexes

Managing Indexes

Maintaining Index Space Efficiency

Increasing Concurrency During Index Checks

Dropping Indexes

Improving Performance for Index Builds

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]