v5d1.ch (9/16/2012)
Thank you joy smith.that article explains lot but i am still bit confused.i understood why we need to rebuild whenever we drop a column.it is beacuse we have tofree up the space used by dropped col but i donot understand why we need to rebuild index when a new col is added.could you please clarify?
Because if you add a column, the new data may cause the clustered index to split pages which is a form of fragmentation that can slow up batch processing quite a bit.
--Jeff Moden
Change is inevitable... Change for the better is not.