Answer:
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