Teradata Database Message 3680 - 3680 - Analytics Database - Teradata Vantage

Message

Too many collected statistics items for this COLLECT command.

Explanation

Because the optimizer uses spool files for generating statistics, when collecting statistics on a table that has too many columns/indexes with statistics collected previously, the total number of spool files needed will exceed its limit. The limit of columns/indexes has been set at 40 according to the limit of spool files.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Instead of using "COLLECT STATISTICS on <table>", collect statistics on each item individually.