Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Managing deleted records
 
From:   Anomy Anom

<-- 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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023