15.00 - Two More Brief Examples - 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)

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.