On which column will you take primary index?

1.Frequently using column.

2.Column that is not changing regularly (Not at all changing values /rarely)

3.By default Teradata database treats first column as PI

Teradata database can distibute the rows based on the uniqueness of the primary index. So generally the primary index is on the unique column should be recommended.

Tweet