Hi All !

A CREATE TABLE....PRIMARY KEY... done on UDB DB2 on Windows, automatically creates a unique index on the primary key. How can you make the primary index a clustered index ?
In the os/390 world, the CREATE TABLE would put the table in a incomplete state. It would be marked as usable only after your create the unique index on the primary key cols. Since it is a seperate create unique index DDL, it was easy to specify the CLUSTER option.


Anil

You would do the following:

1. Create the table without RI (no primary key)
2. Create a unique index on the primary key columns and make it clustered.
3. Create the Primary Key (DB2 will use the index already created)

Hi,

1. create unique index schema.index_name on schema.table_name (col1, col2, etc) CLUSTER
2. alter table schema.table_name add primary key (col1,col2,etc)

Second command will return a warning. Ignore it!

Hope this helps,
Grofaty