Defining a High-Performance Schema
- Table Statistics for Query Optimizer
- ExtentSize, Selectivity, and BlockCount
- Tune Table
- Tune Table Calculated Values
- Exporting and Re-importing Tune Table Statistics
- Define and Build Indexes
- Overview
- Automatically-Defined Indexes
- Defining Indexes
- Summary of Index Types
- Bitmap Indexes
- Bitslice Indexes
- Columnar Indexes
- Building Indexes
- Index Validation
- Using Indexes in Query Processing
- Analyzing Index Usage
- Listing Indexes
- Open, Exists, and Delete Methods
- Choose an SQL Table Storage Layout
- Row Storage Layout
- Columnar Storage Layout
- Mixed Storage Layout
- Indexes on Storage Layouts
- Suggested Application of Row and Columnar Storage
- Define SQL Optimized Tables Through Persistent Classes