15.00 - Example of Computing a Payback Factor for a Simple Join Index - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.00
Content Type
User Guide
Publication ID
B035-1094-015K
Language
English (United States)

Example of Computing a Payback Factor for a Simple Join Index

Suppose you have a frequently performed, non-aggregate join query that you think might benefit from a join index. You decide to test the join index and collect the following data.

 

Parameter

Measured Value (seconds)

ETwo

                                          416

ETw

                                          226

Cost

                                        1055

What is the payback factor for creating this join index?

The interpretation of the benefit percentage is that the time to complete the query is cut nearly in half.

The interpretation of the payback factor is that the cost of creating the join index is recovered if the query is run six or more times.