Enterprise Edition Home
|
Express Edition Home
|
Previous Page
|
Next Page
Index Performance Considerations
In This Chapter
Estimating Index Pages
Index Extent Sizes
Estimating Extent Size of Attached Index
Estimating Extent Size of Detached Index
Estimating Conventional lndex Pages
Estimating Index Pages for Spatial and User-Defined Data
B-Tree Indexes
R-Tree Indexes
Indexes That DataBlade Modules Provide
Managing Indexes
Space Costs of Indexes
Time Costs of Indexes
Removing Unclaimed Index Space
Choosing Columns for Indexes
Filtered Columns in Large Tables
Order-By and Group-By Columns
Avoiding Columns with Duplicate Keys
Clustering
Dropping Indexes
Creating and Dropping an Index in an Online Environment
Circumstances Under Which You Cannot Create or Drop Indexes Online
Creating Attached Indexes in an Online Environment
Using the ONLIDX_MAXMEM Configuration Parameter Before Creating Indexes Online
Improving Performance for Index Builds
Estimating Memory Needed for Sorting
Estimating Temporary Space for Index Builds
Improving Performance for Index Checks
Indexes on User-Defined Data Types
Defining Indexes for User-Defined Data Types
B-Tree Secondary-Access Method
Determining the Available Access Methods
Using a User-Defined Secondary-Access Method
Using a Functional Index
Using an Index That a DataBlade Module Provides
Choosing Operator Classes for Indexes
Operator Classes
Built-In B-Tree Operator Class
Determining the Available Operator Classes
Using an Operator Class
Enterprise Edition Home
|
Express Edition Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]