Data warehousing with Teradata
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment