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