Subject | Re: [firebird-support] FB 2.0 / FB1.5 optimizer difference |
---|---|
Author | Ann W. Harrison |
Post date | 2006-12-04T22:01:15Z |
Hans wrote:
going back to an old ODS and old server. The new gbak is aware of
new features and backs up elements that old gbak's and servers don't
understand.
"fast load" algorithm that also resets selectivity.
Regards,
Ann
> I used a FB1.5 gbak to backup and FB2.0 gbak to restore to ODS11.0That works but is not necessary. You need to use the old gbak when
going back to an old ODS and old server. The new gbak is aware of
new features and backs up elements that old gbak's and servers don't
understand.
> But I read later that FB2.0 gbak can backup ODS10.1 and ODS11.0, but alwaysyThat's right.
> restores to ODS11.0.
> I think that will rebuild the statistics and rebalance the indexes fromYes. Gbak creates indexes after the data is stored, so it uses the
> scratch ?
"fast load" algorithm that also resets selectivity.
Regards,
Ann