Aggregate Join Index. Combines one or more commonly-used columns of the base tables with the results from one or more aggregation expressions pre-computed from one or more columns of the tables. This is used to improve query performance of summarized data.