Boolean
false
Purpose
The DisableAutoReindex parameter is used to disable automatic reindexing of database files by setting the parameter to true. In normal operation of the database, the parameter should not be changed from the default setting of false.
When you set this parameter to true, recovery is terminated and exception 3113 (Database recovery not possible - fatal error encountered) is raised when restart recovery encounters an error redoing or undoing an index update operation. A person who performs the database administration role must then restore the database from backup and perform a roll-forward recovery.
Parameter is read when …
The database server node is initialized; for example, when you restart the database server.