15.00 - Using Named Indexes To Collect Statistics - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Using Named Indexes To Collect Statistics

You can specify an index name or index definition in a COLLECT STATISTICS request. To collect statistics from an unnamed index, you must specify the complete index definition.

Related Topics

The following topics and manuals are related to optimizer statistics:

  • “DROP STATISTICS (Optimizer Form)” on page 810
  • “HELP STATISTICS (Optimizer Form)” on page 956
  • SQL Request and Transaction Processing
  • Database Design
  • Rama Krishna Korlapati, Optimizer Cardinality Estimation Improvements: Teradata Database 12.0, Teradata Database Orange Book 541-0006588A02, 2007.
  • Rama Krishna Korlapati, Teradata 14.0 Statistics Enhancements, Teradata Database Orange Book 541-0009064A02, 2011.