Archives of the TeradataForum
Message Posted: Fri, 20 Jun 2003 @ 14:00:30 GMT
For Teradata, if no stats exist, the optimizer will randomly sample an AMP (RAS) to gather a basis for optimizer costs. It may be the sample vs. actual.
Collect stats on tablename column colunname - will collect stats for the specified columname.
Collect stats on tablename - will recollect stats for all columns/indexes with existing stats. This will not necessarily collect stats on every column of the table - unless every column has statistics present already.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|