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

Teradata Database Design

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

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.