What is Fragmentation ?

 Posted by Pandians on 7/23/2009 | Category: Sql Server Interview questions | Views: 3041

A difference between the physical and logical ordering of index data that can occur when data modifications are made. We can reduce fragmentation and improve read-ahead performance by dropping and re-creating a clustered index (or) DBCC DBREINDEX.

Asked In: In General | Alert Moderator 

Comments or Responses

Login to post response