|
|
Archives of the TeradataForum
Message Posted: Wed, 24 Aug 2005 @ 14:53:19 GMT
Subj: | | Is USI useful for avoiding NUPI row check |
|
From: | | Agrawal, Sunil |
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
| |