Re: Drop/Create index vs bcheck

This is a multi-part message in MIME format. --------------1D692AA73F5B Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Robert Clark wrote: > > What are the relative merits of either drop/create index vs. bcheck? Bcheck (are you really using SE?) or oncheck will perform various checks on the index first; if it finds problems, it wil optionally "repair" the index. It does this by dropping and recreating the index. The "merit" of using bcheck/oncheck is that you know for sure your index was bad before being rebuilt. There is no performance advantage. -- Dave Kosenko, Informix Professional Services **************************************************************************** While it is true that there is more than one way to skin a cat, the cat himself generally fails to appreciate the differences. --------------1D692AA73F5B Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="IFXDISCL.TXT" ************************************************************************* Note: please do not send me email asking about features, or asking about Informix problems and how to solve them. I answer what questions I can in this forum (comp.databases.informix) when I have the time to spare. For questions on features, call your local sales rep or check out the Informix web site (http://www.informix.com). For technical problems, call Informix tech support. ************************************************************************* Disclaimer: All opinions expressed in this message are well-reasoned and insightful; needless to say, they are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. --------------1D692AA73F5B--