Subject | Re: [firebird-support] SWEEP vs Backup & Restore |
---|---|
Author | Ivan Prenosil |
Post date | 2004-05-05T16:55:21Z |
> Suppose I have exclusive access to my db, theoretically, what "should" beIt depends ...
> the quickest way to achieve a SWEEP : Straight SWEEP or Backup & Restore ?
If you have indexes with lots of duplicates, then either backup&restore
or indexes-deactivate&sweep&indexes-activate may be faster.
Ivan