Subject Re: [firebird-support] Re: JOIN PLAN changed after backup/restore.
Author Ann W. Harrison
Adam wrote:
> Perhaps the database before the restore, the database statistics for
> some of the indices were incorrect.

That's quite likely since index statistics are set only when
you run SET STATISTICS or an index fast load. Index fast loads
happen when indexes are created on tables with existing data
and when you set an inactive index to active. Normal operations
do not update the index statistics.