During table alteration, distribution
keys can only be defined if the table resides in a single-partition
database partition group.
About this task
To define distribution keys using the Control Center:
- Open the Alter Table notebook: From the Control Center, expand
the object tree until you find the Tables folder. Click the Tables folder.
Any existing tables are displayed in the pane on the right side of
the window. Right-click the table you want and select Alter from
the pop-up menu. The Alter Table notebook opens.
- On the Keys page, click Add Distribution. The Define Distribution
Key window opens.
- Select the columns that you want to add as distribution key columns
and move them to the Selected columns box.