Hello - I come from an Oracle background where the following holds:
If I create a primary key constraint on a column(s), a unique index is
automatically created (unless one already exists and there are no null values),
with storage parameters I can specify.
Here's a new situation for me on DB2 -
An index already exists on the primary key columns, and I wish to change it to a
If Oracle had clustered indexes (they have something similar.. but that's
another story), I would imagine that I would do something like -
alter index xyz cluster;
This would rebuild the index in a clustered fashion.
How do I do this in DB2 ? Do I have to drop the primary key and put it back
with the cluster argument? Or can I alter the existing index so it will lock the
table and rebuild everything as a clustered index?