15.00 - Effect of Dropping an Index on the IndexNumber Column of DBC.StatsTbl - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Effect of Dropping an Index on the IndexNumber Column of DBC.StatsTbl

When you drop a secondary index on which statistics have been collected. Teradata Database sets the value of the IndexNumber column in DBC.StatsTbl to 0, but it does not drop the statistics that have been collected on the index.