Archives of the TeradataForum
Message Posted: Tue, 17 Jul 2012 @ 15:20:28 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|