 |
 |
Archives of the TeradataForum
Message Posted: Fri, 13 Jan 2012 @ 15:28:01 GMT
| Subj: | | Re: Generate collect statistics statement |
| |
| From: | | Dieter Noeth |
JAMES PARK wrote:
| | The error message was "COLLECT Failed. 5578: Statistics cannot be collected on table DBC.'DBQLEXPLAINTBL' | |
| | And the same errors happened for other tables DBC.DBQLOBJTBL, DBQLOGTBL, DBQLSQLTBL, RESUSAGEIPMA and others. | |
Hi James,
this works on TD13 without error, are you running an old release?
Btw, i wouldn't collect stats on DBQL and ResUsage tables, they grow fast during a day and are usually deleted in a nightly batch, you'd need
to recollect several times a day.
Dieter
| |
