Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 17 Jul 2012 @ 15:20:28 GMT


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


Subj:   UPI with some columns combination and PI with 1 or 2 column
 
From:   sughesh iyyani

Hi Experts,

Kindly let me know what will happen to performance when I am creating a table with

1. UPI with some columns combination.

2. PI with 1 or 2 column.(data skew is not a problem)


Suppose in one scenario data is such that its difficult to create a UPI with a combination of columns( 4 or less).

So, if I am creating a table such that I created UPI which is a combination of 10 columns.

How it will affect system performance like hashing/data distribution and data retrieval?

Or is it good to go with PI?

No need to consider data skew, its only performance.

Kindly let me know.


Thanks in advance,

Sughesh I S.



     
  <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: 27 Dec 2016