If the index on the table was created using a constraint, follow these steps to re-create a clustered index:
Drop the constraint:
alter table huge_tab drop constraint prim_key
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
