Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 31 Oct 2015 @ 15:37:48 GMT

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

Subj:   Re: Multiple single-column SI vs Single Multi-column SI
From:   Anomy Anom

<-- Anonymously Posted: Saturday, October 31, 2015 10:54 -->


Also, please share the disadvantages of having huge number of columns as PI or SI.

In most of the Oracle source systems which loads data into Teradata., PI is defined as their source PK or just to get the uniqueness the developers define huge no. of columns as PI to get uniqueness.

Please share your thoughts on performance disadvantages in detail.

     PI (col1, col2, col3 , .....  col8);

  <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: 24 Jul 2020