Re: Converting 5.x -> 6.0 (was: SET ISOLATION)

At 11:30 PM 3/22/95 GMT, Michael Flannery wrote: >>: migrating from 5.x to 6 or 7, all indexes must be converted (drop and >rebuild). >> >^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ >> >>Is the statement about conversion of indexes really true? The release >notes >>for our 6.0 Informix enginges (Online and SE) (Port for Siemens-Nixdorf >>RMxxx machines under SINIX 5.4x) just say that the database will be >>converted when the 6.0 engine accesses the database for the first time. >> >>Having to recreate all indexes would be a pain in the a..!!! >>Please tell me that we won't have to do that. >> > >Actually, no, you shouldn't have to physically drop and recreate all the >indexes. All you have to do is run update statistics after upgrading >(unless Jon knows something that I don't ;-) ) to 6.X or 7.XX. > >Mike Mike - Yes you can accomplish the index conversion through 'update stats', however my experience has been, that this will take longer. If you have large tables/indexes, speed is important (obviously). Also, when attempting to use update stats to perform a conversion (under an 'early' release), I found that it failed to convert some indexes. These were not discovered until after I 'thought' the conversion was done, and started our application. Well, you can guess what happened.... Jon ================================================================== Jon Vemo Internet: jvemo@cyberspace.com Bothell, WA USA ------------------------------------------------------------------ Watch out for road-kill on the information superhighway....SPLAT!! ==================================================================