Friday, February 4, 2011

More columns in PI(UPI/NUPI) means more performance?

there is a downside to using several columns for a PI. The PE needs every data value for each column as input to the hashing calculation to directly access a particular row. If a single column value is missing, a full table scan will result because the row hash cannot be recreated.

No comments:

Post a Comment