Re: Detached indices in 7.3

SaTriGuy wrote: > > >Just got off the phone with my third-party (financial) software vendor. > >The script that creates their table structure automatically detached all > >indices created (within the same dbspace as the data). After > >researching the "why's" with Informix (<?>), they came to the conclusion > >that this would not be a maintenance problem or a performance issue. > >Besides, they said, Informix 7.3 will not support attached indices. > > > >While I like the flexibility of detaching indices and fragmenting data, > >forcing all indices to be detached could create an administrative > >nightmare. Is this particular rumor true? > > > I just did a quick test of this on my 7.3 engine. It behaved like 7.2 in that > if I didn't say "in dbspace" it created an attached index. > > I wouldn't worry about the detached/attached index business. What we did in > 9.x was to make it so that by default when an index was *created* it would be > detached. However, any existing attached indexes still functioned. In fact, > the catalogue still used attached indexes. Basically we could process attached > indexes, but would create detached ones. > That's OK with me. Just a scare by the vendor, it seems. Still, this discussion has brought up some interesting points. Just when you think you know Informix well enough, boom, something else new to learn and explore . . . even if the marketing stinks. John Carlson Informix DBA WH Smith, Inc. #include <new_knowledge_for_better_Ifmx_efficiency.h>