15.00 - Using Named Indexes To Collect Statistics - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.