Clustered index on Identity field

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,
PradeepIt 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.
Andrew J. Kelly SQL MVP
"Pradeep Kutty" <pradeepk@.healthasyst.com> wrote in message
news:eW2tO%23HtFHA.2656@.TK2MSFTNGP10.phx.gbl...
> 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
>