Archives of the TeradataForum

Message Posted: Thu, 19 Jul 2012 @ 16:01:09 GMT

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

Dave Wellman wrote:

Hi Dave,

i believed this for a long time, too :-(

SET/NUPI plus USI still does duplicate row checks for insert/selects, only single row inserts benefit from the USI.

You can easily see that when you insert/select the same rows a second time:

developer.teradata.com/...

Hopefully the Database Design manual will be fixed soon.

Dieter

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