Subject | Re: [firebird-support] set statistics and GBak |
---|---|
Author | Nando Dessena |
Post date | 2004-09-17T08:57:16Z |
Hello Michael,
M> On a EXISTING DB the set statistics finishes very quickly compared to
M> the making of an index when restoring.
M> This is normal, rigth ?
Quite so. SET STATISTICS is not the same as rebuilding the indexes.
ALTER INDEX <name> INACTIVE followed by ALTER INDEX <name> ACTIVE is.
Ciao
--
Nando Dessena
mailto:nandod@...
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================
M> On a EXISTING DB the set statistics finishes very quickly compared to
M> the making of an index when restoring.
M> This is normal, rigth ?
Quite so. SET STATISTICS is not the same as rebuilding the indexes.
ALTER INDEX <name> INACTIVE followed by ALTER INDEX <name> ACTIVE is.
Ciao
--
Nando Dessena
mailto:nandod@...
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================