Subject | RE: [firebird-support] Re: inner join index optimization problem |
---|---|
Author | ibrahim bulut |
Post date | 2007-11-06T07:19:54Z |
Is backup and restore recompute index statistics?
_____
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Monday, November 05, 2007 9:24 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: inner join index optimization problem
officialz wrote:
much benefit as backup/restore ... with the additional benefit of
being done with the database on-line.
Good luck,
Ann
__________ NOD32 2638 (20071105) Information __________
This message was checked by NOD32 antivirus system.
http://www.eset.com
[Non-text portions of this message have been removed]
_____
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Monday, November 05, 2007 9:24 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: inner join index optimization problem
officialz wrote:
>Recomputing statistics will be much faster and give you nearly as
> The easy fix would be to force regular statistics updates on all
> tables or maybe even do a backup-restore more often.
much benefit as backup/restore ... with the additional benefit of
being done with the database on-line.
Good luck,
Ann
__________ NOD32 2638 (20071105) Information __________
This message was checked by NOD32 antivirus system.
http://www.eset.com
[Non-text portions of this message have been removed]