PPT Slide

DDL Extensions

Purpose: Control placement of database tables across nodes

• Partial declustering
• Overlapped assignment
• Hash partitioning

Example:

CREATE NODEGROUP GROUP1 ON NODES (1 TO 32, 40)

CREATE TABLE PARTS(Partkey int, Partno int) IN GROUP1

PARTITIONING KEY (Partkey) USING HASHING;

CREATE TABLE PARTSUPP(Partkey int, Suppkey int) in GROUP1

PARTITIONING KEY (Partkey) USING HASHING;

Previous slide

Next slide

Back to first slide

View graphic version