in Netezza by (23.9k points)

What should be considered when you are asked to select the distribution key columns for a very large fact table?

A. As many columns as possible.

B. Columns that contain many nulls.

C. Columns contain few unique values.

D. Columns used to join to other large tables.

1 Answer

0 votes
by (23.9k points)

D. Columns used to join to other large tables.

The answer is D.

Related questions

+1 vote
asked Feb 19 in Netezza by rajeshsharma (23.9k points)
0 votes
asked Feb 21 in Netezza by Robindeniel (20.8k points)
0 votes
asked Sep 2 in Android by Robin (14.6k points)
...