Subject causes for disabled indexes
Author Ralf Jansen



Im using firebird embedded (2.5 and 3) in an on-premise solution. I get sometimes reports of slow behaviour and when checking those databases I can see that some or all indexes are disabled.

I can than simply enable those indexes and all seems well afterwards. Gfix does not find any problems and backup/restore works without a problem either then.


Are there some known causes that will result in disabled indexes without breaking the database otherwise?

The application itself doesnt touch indexes directly they just get created at some point.