I'm 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 doesn't touch indexes directly they just get created at