Posted by Gert-Jan Strik on 05/28/05 00:27

Just to add to the previous responses: the DROP_EXISTING feature is
indeed very useful. But there is no reason to shy away from using UNIQUE
constraints (or Primary Key constraints), because CREATE INDEX ... WITH
DROP_EXISTING will also work on indexes that enforce uniqueness of these
constraints.

Gert-Jan

[Back to original message]