How frequently you need to run index maintenance depends on your data and the amount of data changes in the database. As a result, the indexes can become fragmented (on page 1) which can cause queries to run slowly. One of the most common maintenance tasks that are required periodically is rebuilding or reorganizing the indexes in the database to remove fragmentation.
Navis recommends you periodically check for fragmentation and update your indexes as part of your routine database maintenance.
You should also perform index maintenance the SQL Server database whenever you apply the yard model changes to a yard using the N4 Yard Editor.
Before you remove fragmentation:
Analyze the database for fragmentation. (on page 1) Do this during off-peak hours.
Depending on the degree of fragmentation, decide whether to reorganize the indexes or rebuild the indexes. If you cannot rebuild indexes, you can update statistics as a temporary solution. See Methods to remove fragmentation on indexes (on page 1).
Review Defragmentation best practices (on page 1).
Navis provides a script which finds fragmentation and generates the alter statements for removing fragmentation. See Remove fragmentation with alter statements (on page 1) for instructions.