15.00 - Join Index Benefits and Costs - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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.