15.00 - Two More Brief Examples - Teradata Database

Teradata Database Design

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

Two More Brief Examples

The following examples work through the following join indexes.

  • In-place simple join index
  • Ad hoc aggregate join index
  • 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.