15.00 - Cost/Benefit Analysis for Join Indexes - Teradata Database

Teradata Database Design

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

Cost/Benefit Analysis for Join Indexes

This topic introduces the concepts of cost/benefit analyses for various types of join indexes. Several different computations are described to support these analyses including the following metrics.

  • Cost
  • Benefit
  • Benefit percentage
  • Payback
  • Query ratio