You can define a new primary index or primary AMP index for a new table using the CREATE TABLE AS syntax.