| Subject | Re: [firebird-support] Re: slow query fixed after backup |
|---|---|
| Author | Ann Harrison |
| Post date | 2011-06-22T20:22:49Z |
On Wed, Jun 22, 2011 at 1:16 PM, emb_blaster <EMB_Blaster@...> wrote:
Cheers,
ann
>> By the other hand, when I do a backup-restore, the same query runs whithout any problem, the report takes few second to show up in the preview tool I'm using...No. Backup/restore updates the index statistics.
>>
>> If it was a problem with bad plan selection, wouldn't it persist after the backup-restore?
>>
Cheers,
ann