For guidelines and suggested tools for collecting statistics, see the following:
- “COLLECT STATISTICS (Optimizer Form)” in SQL Data Definition Language
SQL Request and Transaction Processing:
- “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 SQL Data Definition Language.
- Teradata Viewpoint Stats Manager portlet described in Viewpoint documentation.