Use > JMX Reference > Modeling Methods > How to Rebuild Indexes on Microsoft SQL Database

How to Rebuild Indexes on Microsoft SQL Databases

UCMDB is an online transaction processing (OLTP) application. It performs many insert, update, and delete operations each day, its indexes might become fragmented. The index fragmentation could be even higher if discovery jobs that run also modify the data.

To help rebuild fragmented indexes on Microsoft SQL database, the RebuildIndexes job is introduced. It uses a stored procedure to defragment the indexes. The RebuildIndexes job is deactivated by default. You can start the job manually when necessary.