Assume that you define the following primary-indexed table.
CREATE TABLE source ( column_1 INTEGER column_2 INTEGER) UNIQUE PRIMARY INDEX (column_1);
The following CREATE TABLE … AS requests both produce primary-indexed tables; however, the second creates the table with a nonunique primary index.
CREATE TABLE target AS source WITH NO DATA; CREATE TABLE target AS (SELECT column_1, column_2 FROM source) WITH DATA PRIMARY INDEX (column_1);