Physical Database Design

6.8 Topology Design 117

6.8 Topology Design

6.8.1 Using Subsets of Nodes

To achieve an optimal topology in table storage and data access it may be preferable

not to use all nodes for tables that are moderately small in size. Similarly it may be

optimal to keep tiny tables on a single node. Some database designers like to use ded-

icated nodes for ETL processing, another reason to have dedicated nodes for specific

subtasks. These are generally referred to as partition groups (or, alternatively, node

groups). Partition groups are subsets of nodes. Tables can be created in partition

groups so that their data is spread across only a subset of nodes.

In F ...