Two More Brief Examples
The following examples work through the following join indexes.
Follow the identical procedure to that used in the detailed example.
For the in-place simple join index, the calculation is as follows.
To recover its cost in a 30 day period, this query must be run slightly more than once per business day.
For the ad hoc aggregate join index, the calculation is as follows.
To recover its cost in a 30 day period, this query must be run once per week.