“Let me once again explain the rules. The Greenplum Data Warehouse Rules!”
- Tera-Tom Coffing
1.Tables are either Distributed by Hash or Distributed Randomly.
2.Tables are either stored in a heap or are append-only tables.
3.The rows of a table by default are unsorted in a heap or they can be physically sorted with a clustered index.
4.Tables are stored physically on disk in either a row or columnar format.
5.Tables can be partitioned.
6.Tables are either permanent, temporary or external Tables.
7.Table can have Primary and Foreign Key constraints although Foreign Key constraints are not enforced.
8.Tables can have Unique constraints and other Boolean constraints.