Archives of the TeradataForum
Message Posted: Wed, 24 Aug 2005 @ 14:53:19 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|