Archives of the TeradataForum

Message Posted: Tue, 30 Jun 2009 @ 14:00:13 GMT

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

<-- Anonymously Posted: Tuesday, June 30, 2009 09:51 -->

Hello Anomy,

Multiload does support NUSI (Assuming that you are using a flag to denote active and deleted records).

Even if you chose to create a NUSI on the column, it is doubtful that teradata would use it because it may find that the FTS is 'cheaper' (unless of course it could bitmap in conjunction with other NUSIs, which you don't seem inclined to define) .

Best Regards

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