Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 26 Sep 2005 @ 10:17:22 GMT


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


Subj:   Re: Design Considerations for FS-LDM/3NF model
 
From:   Khan, Rehan

Index is usually based on better distribution of data. As the performance of any TD machine is governed by its slowest AMP. To get uniqueness NUSI are implemented. One other important consideration in PI is the most used join column, to avoid duplication/ redistribution of data during joins.

To get a better understanding about TD indexes please go through Database design(1094.pdf) in Teradata documentation.


_______________________________ Best Regards,

Rehan A. Khan, PMP
Teradata Certified Master
Program Manager, TD Development
Teradata, A Division of NCR



     
  <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: 23 Jun 2019