15.00 - 3680 Too many collected statistics items for this COLLECT command. - 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)

3680 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.

Remedy:

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