How do I choose a Distkey?

Choose the best distribution style

  1. Distribute the fact table and one dimension table on their common columns. Your fact table can have only one distribution key. ...
  2. Choose the largest dimension based on the size of the filtered dataset. ...
  3. Choose a column with high cardinality in the filtered result set. ...
  4. Change some dimension tables to use ALL distribution.

Related posts: