Using constraints and alter table

If the index on the table was created using a constraint, follow these steps to re-create a clustered index:

  1. Drop the constraint:

    alter table huge_tab drop constraint prim_key
    
  2. Re-create the constraint, thereby re-creating the index:

    alter table huge_tab add constraint prim_key
        primary key clustered (key_col)
        on big_demo_seg