Archives of the TeradataForum

Message Posted: Wed, 24 Aug 2005 @ 14:53:19 GMT

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

In order to avoid the NUPI duplicate row check, we should enforce uniqueness by defining a USI. This will enhance the performance. Also Teradata document says that while inserting large number of records we should remove the SI and recreate them once the insertion is done which will improve the performance. Isn't these two statement contradicting each other because if we will remove the SI while inserting, this will allow duplicate row check.

Appreciate your help in clarifying this.

Regards,

Sunil

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