Archives of the TeradataForum
Message Posted: Tue, 15 Jul 2003 @ 23:24:56 GMT
| Subj: | | Re: Collect stats on DBC. |
| |
| From: | | Chris Coffing |
We have run the collect stats on DBC and made the error of running it on all columns.
You should not run collect stats on dbc.tvm... It doesn't like that and you will get wierd unwanted issues in the warehouse.
All the other tables seem to be OK. We saw some improvements for logins but not many other performance gains. We certainly didn't
record any major findings. Don't know if it helps outside of the DBC.TVM issue...
| 
