A join index is an indexing structure containing columns from one or more base tables and is generally used to resolve queries and eliminate the need to access and join the base tables it represents.
Join indexes can be defined in the following general ways.
- Simple or aggregate
- Single-table or multitable
- Hash-ordered or value-ordered
- Complete or sparse
See Join Indexes.