- Map Option Usage with CREATE JOIN INDEX
- CREATE JOIN INDEX Locks and Concurrency
- Working with Join Indexes
- Partitioned Tables and Join Indexes
- Distribution of Join Index Rows
- Guidelines for Row-Partitioned PI Join Indexes
- Choosing between a Row-Partitioned Join Index and a Value-Ordered NUSI for Covering Range Queries
- Column-Partitioned Join Indexes
- Simple Join Indexes
- Aggregate Join Indexes
- Sparse Join Indexes
- Join Indexes, Expressions, and Built-In Functions
- Collecting Statistics on Join Indexes
- Collecting Statistics on a Single-Table Join Index
- Collecting Statistics on Base Table Columns Instead of Single-Table Join Index Columns
- Guidelines for Collecting Statistics on Single-Table Join Index Columns
- Collecting Statistics on Multitable Join Indexes
- Compression of Join Index Column Values
- Row Compression of Join Indexes
- Physical Join Index Row Compression
- CREATE JOIN INDEX Restrictions and Limitations
- Rules and Restrictions for Join Indexes
- Query Coverage by Join Indexes
- Rules and Restrictions for Query Coverage in Join Indexes