Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

The values might be incorrect due to out-of-date space usage information. To update the values, use the DBCC UPDATEUSAGE command to recalculate the space usage fields. For more information, see SQL Server Books Online for DBCC UPDATE USAGE.

 


Anchor
Examiningfragmentationoftabledataandindexes
Examiningfragmentationoftabledataandindexes
Examining fragmentation of table data and indexes

...

The Recommend Indexes output shows a list of recommended indexes and statistics. For each recommended item, detailed information is displayed in the Details area, such as a list of key columns and the DDL of the Create Index or Statistics text.

 

...

.

...