Query and Workload Analysis Limits - Teradata Database

Parameter

Value

Maximum size of the Index Wizard workload cache.

The default is 48 MB and the minimum is 32 MB.

187 MB

Maximum number of columns and indexes on which statistics can be collected or recollected at one time.

512 or limited by available parse tree memory and amount of spool.

512

Maximum number of pseudo indexes on which multicolumn statistics can be collected and maintained at one time.

A pseudo index is a file structure that allows you to collect statistics on a composite, or multicolumn, column set in the same way you collect statistics on a composite index.

This limit is independent of the number of indexes on which statistics can be collected and maintained.

32

Maximum number of sets of multicolumn statistics that can be collected on a table or join index if single‑column PARTITION statistics are not collected on the table or index.

32

Maximum number of sets of multicolumn statistics that can be collected on a table or join index if single‑column PARTITION statistics are collected on the table or index.

31

Maximum size of SQL query text overflow stored in QCD table QryRelX that can be read by the Teradata Index Wizard.

1 MB