Computing the Payback Factor
This topic explains how to calculate the payback factor for a join index. Note that the term Costs is something you must measure. It is the time required to compute the join index being investigated.
where:
|
Syntax element … |
Specifies … |
|
Costs |
the processing time required to create the join index. |
Because the term payback factor represents a number of queries, it is always rounded up to represent a whole number. The smaller the payback factor, the sooner benefits accrue from using the join index.