Depending on the complexity of the joins or the cardinalities of base tables that must be aggregated, join indexes optimize the performance of certain types of workloads.
- Selecting the Primary Index for Join Indexes
- Selecting Secondary Indexes for Join Indexes
- Statistics and Other Demographic Data for Join Indexes
- Guidelines for Collecting Statistics on Multitable Join Indexes
- Guidelines for Collecting Statistics on Single-Table Join Indexes
- Collecting Statistics on Base Table Columns Instead of Single-Table Join Index Columns
- Guidelines for Collecting Statistics On Single-Table Join Index Columns