15.00 - 5782 Non-Indexed statistics already exist on the specified set of indexed fields. - Teradata Database

Teradata Database Messages

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

5782 Non-Indexed statistics already exist on the specified set of indexed fields.

Explanation:

Statistics were previously collected on the set of columns comprising this index. At the time of this previous collection, the set of columns were not indexed. The existing statistics should be dropped using the COLUMN list syntax and then statistics can be collected on this index.

Generated By:

OPD modules.

For Whom:

End User.

Remedy:

Drop the statistics defined on the set of non-indexed fields.