Thursday, February 10, 2011

How do you choose Primary Index for a table in teradata?

A great Primary Index will have:

A Value Access frequency that is high
A Join Access frequency that is high
Reasonable distribution (i.e unique)
A change rating below 2

No comments:

Post a Comment