Index Rebuild
Also known as the NIGHT mode. This feature rebuilds all indexes for each table it maintains, reducing the fragmentation of indexes and improving preponderance. This is a blocking operation that can fail if the application runs a query against a table that is currently being maintained.
Therefore, this operation only occurs in the time interval passed by the parameter. The idea is to choose an interval where the database is not used at all to avoid problems.
NIGHT mode is more effective but is blocking and potentially breaks the application due to database maintenance.
It rebuilds indexes and reduces table fragmentation, but it takes some time (several minutes), depending on the table size.
A deadlock may occur when attempting to query a table that is currently being maintained. If this happens, the session performing the query can be chosen as a deadlock victim and killed, ultimately resulting in a database exception.