Home Page for the TeradataForum

Archives of the TeradataForum

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

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