For guidelines and suggested tools for collecting statistics, see the following:
- “COLLECT STATISTICS (Optimizer Form)” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
- SQL Request and Transaction Processing, B035-1142:
- “Query Capture Facility”
- Submit the SHOW STATISTICS statement with either the SUMMARY option to see summary statistics or the VALUES option to see detailed statistics. For more information, see “SHOW STATISTICS (Optimizer Form)” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
- Teradata Viewpoint Stats Manager portlet described in Viewpoint documentation.