Subject | Re: [firebird-support] Fixing corrupted indexes without restoring |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2010-06-09T16:23:08Z |
09.06.2010 18:10, Maya Opperman wrote:
For the rest SET STATISTICS is enough.
Use IBAnalyst or FBDataGuard to watch your DB.
--
SY, SD.
> I just want to double check that the following is safe to do, and won'tIt isn't safe and it isn't necessary. Rebuild only corrupted indexes.
> result in users being able to post duplicate keys, if something goes
> wrong with reactivating an index for some odd reason:
For the rest SET STATISTICS is enough.
Use IBAnalyst or FBDataGuard to watch your DB.
--
SY, SD.