Home
|
Previous Page
|
Next Page
Planning Table and Index Fragmentation
In This Chapter
Identifying Fragmentation Goals
Issues for DSS clients
Issues for operational data stores
Issues for OLTP clients
Data availability, recovery, backup, and restore issues
Planning a Fragmentation Strategy
Examining Your Data and Queries
The Table-Access Pattern
The Data-Distribution Pattern
Using Data-Distribution Pattern Information
Evaluating Fragmentation Factors for Both DSS and OLTP Clients
Specific OLTP Requirements
Specific DSS Requirements
Choosing Fragmentation Schemes
Fragmentation Methods
Round-Robin Fragmentation
Expression-Based Fragmentation
Hash Fragmentation
Hybrid Fragmentation
Range Fragmentation
Index Fragmentation Guidelines
Attached Indexes
Detached Indexes
Temporary-Table Fragmentation
Planning Storage Spaces to Support Fragmentation Schemes
Planning the Disk Space Strategy
Chunk and Dbspace Configuration
Disk Configuration Guidelines
Planning and Creating Cogroups and Dbslices
Creating Dbslices to Increase Data Granularity
Creating Dbslices for Collocated Joins
Planning Storage Spaces to Optimize Backup Performance
Verifying Fragmentation Efficiency
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]