Archives of the TeradataForum
Message Posted: Tue, 13 Jan 2009 @ 12:52:13 GMT
(Sorry for the delayed response)
Based on the information that you've given it looks like this table is @ 234GB in size which is going to have three full table scans to re- collect all stats.
I should also have asked - what size is your Teradata system ? Number and types of Nodes.
How long does a full table scan take against this table ? The Collect Stats processing will probably be longer because it will skew (heavily!).
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|