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.
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: 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 |