When creating tables in Aster Database, follow these guidelines:
- Each table must be either a fact table or a dimension table.
- Because Aster Database physically distributes most tables, the rows of each distributed table are stored throughout the cluster. The Distribute By field in the Storage tab of the Table object form enables you to control distribution of data by specifying a distribution key.
- Optionally you can partition data in a large table into child partitions. Partitioning can enable faster query responses. The Partition by field in the Storage tab of the Table form enables you to control how data is partitioned.
For more information about table types in Aster Database, see the Aster Database User Guide.