Archives of the TeradataForum

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

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

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>>