Forum Discussion
Oversize index
I have a table with 220 rows. It has about 20 columns. One of the non-clustered indexes has a datetime as the key value and includes a unique identifier and a varchar(128). The clustered PK is a bigi...
Hello Bruce,
Is that a clustered index? Then fragmentation can be the cause for the high index size.
Defrag the index daily or change it to a non-clustered index.
Olaf
Is that a clustered index? Then fragmentation can be the cause for the high index size.
Defrag the index daily or change it to a non-clustered index.
Olaf
Hi olafhelper , Nope, it is a non-clustered index. The primary key is the clustered index.