Page History

...

Low page density can cause SQL Server to read more pages than necessary when using an index, such as when performing a query. When data is initially stored on the pages, SQL Server uses the fillfactor fill factor value to determine how much data to store on each page. At this point, page density is relatively high, but the page density becomes lower as data is inserted and pages are split to make room for the additional data. SQL Defrag Manager can reorganize or rebuild indexes to increase page density and reduce the number of reads when using the index.

...

Use this feature to update the view of objects found on a specific server, a database, or a table. Right-click the specific server, database, or table and select the Rediscover Objects option.

...