15.10 - Tuning the Workload Cache Limits for Index and Partition Analysis - Teradata Database

Teradata Database SQL Request and Transaction Processing
prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
User Guide
featnum
B035-1142-151K

Index Wizard processing in Teradata Database allocates workload cache for the purpose of caching information retrieved from the QCD and other temporary working structures that are needed during the Analysis and Validation phases of recommending indexes and partitioning expressions for various SQL workloads.

Two DBS Control performance group fields control the respective workload cache sizes for the Analysis and Validation phases.

  • IAMaxWorkloadCache
  • IVMaxWorkloadCache

    • The following table provides some of the details for these fields. See Utilities for further information.

     

    Field

    Purpose

    Valid Range (megabytes)

        Default (megabytes)

    IAMaxWorkloadCache

    Defines the maximum size of the Index Wizard workload cache for Analysis operations.

    This field is applicable to the following SQL statements only:

  • INITIATE INDEX ANALYSIS
  • INITIATE PARTITION ANALYSIS

    • See “INITIATE INDEX ANALYSIS” and “INITIATE PARTITION ANALYSIS” in SQL Data Manipulation Language for details about these statements.

    32 - 187

    32

    IVMaxWorkloadCache

    Defines the maximum size of the Index Wizard workload cache for Validation operations.

    This field is applicable to all SQL statements issued within a session when DIAGNOSTIC "Validate Index" has been enabled.

    See “DIAGNOSTIC “Validate Index”” in SQL Data Definition Language for details about this statement.

    1 - 32

    1