Subject Re: [firebird-support] Re: inner join index optimization problem
Author Ann W. Harrison
officialz wrote:
> The easy fix would be to force regular statistics updates on all
> tables or maybe even do a backup-restore more often.

Recomputing statistics will be much faster and give you nearly as
much benefit as backup/restore ... with the additional benefit of
being done with the database on-line.

Good luck,