Hi All,

I have heard that if you create a clustered index on identity column(PK
also) it would decrease the page splits. But how?

Thanks,
Pradeep

It will eliminate page splits on inserts since all new rows get appended to
the end of the current page.  It does not stop pagespilts due to updates on
existing rows on columns with variable lengths.  But in any case that should
not be your sole motivation for where you place the Clustered Index. You can
also avoid or minimize page splits with a proper fill factor.

Show quoteHide quote

ROWS with null values getting truncated.
Dynamic order by case expression problem
Generating an Index
complicated update (for me)
table update trigger update second table