Cluster Index with Drop Existing

CREATE CLUSTERED INDEX cixEmp
on Employee_InfoV2(emp_id)
with
(
DROP_EXISTING = ON,
sort_in_tempdb = ON,                 
FILLFACTOR = 80,         
PAD_INDEX = ON
)


Clause :

DROP_EXISTING = ON ----> if index exists, drop it  then recreate.

sort_in_tempdb = ON  ----> sort index operation in tempb

FILLFACTOR = 80 ---->fill each index page 80%. remaining 20% free,

PAD_INDEX = ON ----> If  Fillfactor is 80% ,then  each data page(Intermediate page in B-tree) will be  80% full remaining 20% free.

• Tweet
• Share
• Share
• Share
• Share