Archives of the TeradataForum

Message Posted: Fri, 18 Jan 2002 @ 15:37:28 GMT

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

Claybourne,

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
TFS Consulting
www.tfsconsulting.com

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