This will automatically update the contents and page numbering of the index.
When is specified, all indexes on the table are dropped and rebuilt in a single transaction.
Reorganizing an index uses minimal system resources.
Fragmentation exists when indexes have pages in which the logical ordering, based on the key value, does not match the physical ordering inside the data file.
Heavily fragmented indexes can degrade query performance and cause your application to respond slowly, especially scan operations.
Because an index in Microsoft Word is simply a field code, it can be updated in the same manner that a Word table formula can.
Updating an index in Microsoft Word can save you a lot of work when making changes to your index, especially if working on documents that are often revised.
You must then rebuild the entire index or, for a global index, each of its partitions.
The database lets you override this default behavior if you specify statement for the maintenance operation.
The SQL Server Database Engine automatically modifies indexes whenever insert, update, or delete operations are made to the underlying data.
Over time these modifications can cause the information in the index to become scattered in the database (fragmented).
For more information about Note Rebuilding or reorganizing small indexes often does not reduce fragmentation.