Archives of the TeradataForum
Message Posted: Fri, 01 Sep 2006 @ 14:16:41 GMT
| Subj: || || Collect Statistics Takes 11 Hours |
| From: || || Anomy Anom |
<-- Anonymously Posted: Friday, September 01, 2006 08:11 -->
We have a cron job that collect statistics on a table with 177,486,506 rows. This collect statistics statement takes over 11 hours. If we run
collecting on columns and indexes it takes 2 hours. We have collect statistics on tables that are almost as bad, but this is the worse offender.
We're at the point where we are open to anything right now. Anybody have any suggestions or ideas? Thanks