Cost/Benefit Analysis of Join Indexes - Teradata Vantage - Analytics Database

Database Design

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ogg1628096130566.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zqc1472244571611
lifecycle
lifecycle
Product Category
Teradata Vantageā„¢

Any query performs faster when it uses a join index than it does without a join index. The issue that must be examined is whether or not the benefit of the decreased response times provided by a join index offset the costs of its creation, maintenance, and storage.

The relative costs and benefits of defining a join index are described in Cost/Benefit Analysis for Join Indexes.