Re: Detached indices in 7.3

>W. H. SMITH wrote: >> >> Informix 7.23.UC4 >> HPUX 10.01 >> >> 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? > >Not that I've heard or seen. My 7.3 Beta machine suffers from heart >failure so I cannot verify but I do not remember seeing detached >extents belonging to attached indexes. > > I think this is a rumor only. I just ran a quick test on my 7.3 engine and my indexes were attached. Even so - I would not worry about detached/attached indexes. If this is implemented like it is in 9.x, then the indexes will be created as detached, but existing attached indexes will be functional. There is a performance benifit by having detached indexes inplace of attached indexes (i.e. data scans do not have to "skip" pages), and the total space required should be identical. Madison Pruet