Archives of the TeradataForum
Message Posted: Fri, 18 Jan 2002 @ 15:37:28 GMT
Keep in mind that the 'CREATE TABLE AS..' allows for multiple options. For example, the query used does not have to be a direct copy of another table. It could be a multi-join query, in which case there is no way for Teradata to determine whether set or multiset is required. In any case, the query portion really only determines the columns of the resulting table. The other parameters of a CREATE TABLE statement still need to be applied, such as set|multiset, fallback, etc.
Regarding stats, the same rules apply. Stats for the resulting table based on the source data really only apply in a situation where you are creating a table based on the exact image of an existing table.
I hope this makes some sense.
Thomas F. Stanek
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|