Home
|
Previous Page
|
Next Page
Managing Databases
>
Table Fragmentation Strategies
In This Chapter
What Is Fragmentation?
Why Use Fragmentation?
Whose Responsibility Is Fragmentation?
Enhanced Fragmentation (XPS)
Fragmentation and Logging
Distribution Schemes for Table Fragmentation
Expression-Based Distribution Scheme
Range Rule
Arbitrary Rule
Using the MOD Function (IDS)
Inserting and Updating Rows
Round-Robin Distribution Scheme
Range Distribution Scheme (XPS)
System-Defined Hash Distribution Scheme (XPS)
Hybrid Distribution Scheme (XPS)
Creating a Fragmented Table
Creating a New Fragmented Table
Creating a Fragmented Table from Nonfragmented Tables
Using More Than One Nonfragmented Table
Using a Single Nonfragmented Table
Rowids in a Fragmented Table
Fragmenting Smart Large Objects (IDS)
Modifying Fragmentation Strategies
Reinitializing a Fragmentation Strategy
Modifying Fragmentation Strategies for Dynamic Server
Using the ADD Clause
Using the DROP Clause
Using the MODIFY Clause
Modifying Fragmentation Strategies for XPS
Using the INIT Clause
Using ATTACH and DETACH Clauses
Granting and Revoking Privileges from Fragments (IDS)
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]