Archives of the TeradataForum

Message Posted: Thu, 26 Aug 2004 @ 12:34:00 GMT


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

Subj:		Re: MULTISET Vs SET tables

From:		Coffing Christopher L

Mark

That is quite right... Another gotcha that I have seen when creating a table using the "AS SELECT" statement is the Primary Index is not always duplicated from the source table. Not sure if this is a feature but I make sure that I always define the Indexes and do not rely on the Defaults.

Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master