Archives of the TeradataForum

Message Posted: Fri, 01 Sep 2006 @ 14:16:41 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>