 |
 |
Archives of the TeradataForum
Message Posted: Thu, 12 Aug 2004 @ 09:26:20 GMT
| Subj: | | Re: UNION And INSERT INTO |
| |
| From: | | Victor Sokovin |
| | My query to anyone who would know is whether this then removes the duplicate row checking process when the rows are inserted into the
CREATE SET table? or would this step still take place because of the table definition. | |
An easy and reliable way to tell would be to create a MULTISET table and compare the run times. I am not aware of any UNION specific
exceptions in checks for duplicates with SET tables. If the check will be done, the test will give you an idea of the overhead in your particular
case.
Regards,
Victor
| |
