 |
 |
Archives of the TeradataForum
Message Posted: Sun, 22 Jul 2012 @ 19:48:11 GMT
| Subj: | | Re: Insert statement starts OK but then slows down |
| |
| From: | | Dieter Noeth |
Sravan Kumar Bodla wrote:
| | Does the below statements correct? | |
| | SET --- UPI ---- duplicates will not be allowed double checks each row? | |
No duplicates allowed, but no need to do a duplicate row check, only PI data is checked for duplicate values
| | SET --- PI ---- duplicates will not be allowed, no double checks? | |
No duplicate rows allowed, thus needs to check all columns for rows with the same PI values.
| | MULTISET --- UPI ---- Duplicates will not be allowed, no double check for each row? | |
ack, only PI data is checked for duplicate values
| | MULTISET --- pi ---- Duplicates will be allowed, no double checks? | |
ack
Dieter
| |
