Re: Drop/Create index vs bcheck

Posted in 1996

"Malcolm Weallans" — Thu, 14 Mar 1996 23:35:07 GMT — source: Informix-list mailing list archive (1991-1998)

> > What are the relative merits of either drop/create index vs. bcheck? > > Robert Clark > > -------------------------------------------------------------- > e-mail: robert@clark.netkonect.co.uk > snail: 12 Balvernie Grove, Wandsworth, LONDON, SW18 5RU, UK. > -------------------------------------------------------------- Robert, bcheck is designed to be used following a hardware or software crash. It's function is to make the .dat and .idx files consistent. It also reports errors found which might indicate other inconsistencies. If bcheck shows more than one or two errors you should really go back to archive and rollforward. That is not the same as DROP and RE-CREATE index. If any data has been lost due to the HW/SW failure DROP /CREATE INDEX will definitely miss the invalid data. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc