For information about collecting and dropping Optimizer statistics, see the following:
- COLLECT STATISTICS (Optimizer Form)
- “COLLECT STATISTICS (Optimizer Form)” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
- DROP STATISTICS (Optimizer Form)
- “DROP STATISTICS (Optimizer Form)” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
For information about reporting detailed Optimizer statistics, see the following:
- SHOW STATISTICS
- “SHOW STATISTICS” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
Also see Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142 and Teradata Vantage™ - Database Design, B035-1094 for information about statistics, their collection, and their recollection.