Join Index Benefits and Costs - Teradata Database

Join Index Benefits and Costs

Before you create a join index to optimize one or more of your frequently repeated queries, you should consider the following issues carefully:

Cost of disk resources required to store a join index

Cost of creating a join index

Cost of maintaining a join index

Benefits of reduced performance times for the queries the join index is designed to facilitate.