For information about collecting and dropping Optimizer statistics, see the following:
- COLLECT STATISTICS (Optimizer Form)
- DROP STATISTICS (Optimizer Form)
- COLLECT STATISTICS and 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.