Archives of the TeradataForum
Message Posted: Sat, 18 Aug 2001 @ 04:01:52 GMT
The reason the CREATE TABLE is taking so long is due to duplicate row check.
The table create builds a SET table(no dup rows). However, since a unique column can not be defined using this form of the create, the system must verify that you are not attempting to slip a duplicate row into the table. As soon as there is a UPI or USI, it enforces the unique row because a column is unique.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|