 |
 |
Archives of the TeradataForum
Message Posted: Sat, 18 Aug 2001 @ 04:01:52 GMT
| Subj: | | Re: CREATE TABLE AS??? |
| |
| From: | | Michael Larkins |
Hi Tony:
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.
Best regards,
Mike
| |
