An aggregate operation calculates a single value from individual column values in several rows of a table. Examples of aggregate operations are sums and averages calculated from sets of column values. If the same aggregate operation is frequently performed on the same columns, an aggregate JI can improve query performance, because Vantage can use the aggregate JI to satisfy queries, rather than repeating the aggregate calculations for every query. You can define aggregate JIs on one or more tables.