Archives of the TeradataForum
Message Posted: Tue, 24 Jul 2012 @ 09:21:11 GMT
| Subj: || || Re: Collect stats on tables rather than columns |
| From: || || Pluebell, Fred |
The Teradata COLLECT syntax that includes only the table name without any column / index specifications indicates that you want to re-collect
(refresh) all previously collected column / index statistics. There are no "entire table" statistics as such. If you attempt to use the "table
only" form before any column / index statistics have been collected, you will get an error.