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

Teradata Database SQL Data Definition Language Detailed Topics

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

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.