Archives of the TeradataForum

Message Posted: Thu, 19 Jul 2012 @ 13:46:16 GMT

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

Hi,

Bodla, Sravan Kumar wrote:

No.

If the table has a unique index (either upi or usi) then you will ** not ** have a problem with 'duplicate row checks'.

The only time you have problems with duplicate row checks is when:

- the table is SET, AND

- the table has NO unique indexes, AND

- you have lots of rows with the same PI rowhash value.

If any of the above conditions are NOT met then you will not have a problem with duplicate row checks during insert processing.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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