...
It will also make it clearer for users when using the application as legacy features will no longer be visible.
...
Summary:
Reorganize SQL Server indexes to improve query performance and reduce resource consumption
Ticket:
https://bigdigit.atlassian.net/browse/SWMS-3559
Detail:
Over time, indexes have pages where logical ordering (based on the key-value) differs from the physical ordering inside the data file. This means that there is a high percentage of free space on the index pages and that SQL Server has to read a higher number of pages when scanning each index.
Index fragmentation can result in decreased efficiency of queries and impact SQL Server performance.
The solution to fragmented indexes is to reorganize indexes. Index reorganization is a process where SQL Server goes through the existing index and cleans it up.
We have identified tables with high fragmentation and will perform index reorganization on these.
...