Hello.

Is there any situation in which an index would be inactivated automatically by the system?


We recently been debugging a database in which 2 indexes related to foreign keys mysteriously got inactivated.

We are not sure if this might happen during a backup/restore, or any other procedures like that.

This database is on firebird 3.0.4, although we have been using firebird for over 10 years and I don’t remember seeing a single case like that.





Atenciosamente,

Rudi Feijó


Multidados Informática Ltda.
* (11) 2579-8789

* <mailto:ariane.cutlac@...> rudi.feijo@...
* <http://www.multidadosti.com.br/> www.multidadosti.com.br
* www.whatsappmailing.com.br <http://www.whatsappmailing.com.br>



[Non-text portions of this message have been removed]