Cost/Benefit Analysis for Join Indexes - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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