Teradata Database Message 5782 - 5782 - Analytics Database - Teradata Vantage

Message

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.

Notes

None

Remedy

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