Database Maintenance: ReIndexing (4374229)

Identity Manager Database Maintenance best practices: ReIndexing

#1 For tables that are less than 1GB, or have less than 1 million records, there is a built-in scheduled task called "Rebuild table index".

The job runs nightly, if needed reconfigure its running schedule to run more often.

#2 For larger tables (more than 1GB, or have more than 1 million records), there is no built-in task.

As per the official documentation:
"Reindexing of tables does not take place anymore if they are larger than 1 GB or have more than 1 million data records. Maintenance of these tables must be performed by the database administrator within maintenance periods."

https://support.oneidentity.com/technical-documents/identity-manager/9.0%20lts/operational-guide/10#TOPIC-1846406

This falls into the general system maintenance and should be discussed with a Database Administrator.

Additionally, here are some resources which can help on how to run these reindexing maintenance tasks:
 
https://learn.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver16
https://www.sqlshack.com/how-to-identify-and-resolve-sql-server-index-fragmentation/