Enterprise Edition Home
|
Express Edition Home
|
Previous Page
|
Next Page
Fragmentation Guidelines
In This Chapter
Planning a Fragmentation Strategy
Setting Fragmentation Goals
Improving Performance for Individual Queries
Reducing Contention Between Queries and Transactions
Increasing Data Availability
Increasing Granularity for Backup and Restore
Examining Your Data and Queries
Considering Physical Fragmentation Factors
Designing a Distribution Scheme
Choosing a Distribution Scheme
Designing an Expression-Based Distribution Scheme
Suggestions for Improving Fragmentation
Fragmenting Indexes
Attached Indexes
Detached Indexes
Restrictions on Indexes for Fragmented Tables
Fragmenting Temporary Tables
Using Distribution Schemes to Eliminate Fragments
Fragmentation Expressions for Fragment Elimination
Query Expressions for Fragment Elimination
Range Expressions in Query
Equality Expressions in Query
Effectiveness of Fragment Elimination
Nonoverlapping Fragments on a Single Column
Overlapping Fragments on a Single Column
Nonoverlapping Fragments, Multiple Columns
Improving the Performance of Attaching and Detaching Fragments
Improving ALTER FRAGMENT ATTACH Performance
Formulating Appropriate Distribution Schemes
Ensuring No Data Movement When You Attach a Fragment
Updating Statistics on All Participating Tables
Improving ALTER FRAGMENT DETACH Performance
Fragmenting the Index in the Same Way as the Table
Fragmenting the Index Using Same Distribution Scheme as the Table
Monitoring Fragment Use
Using the onstat Utility
Using SET EXPLAIN
Enterprise Edition Home
|
Express Edition Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]