Re: Detached indices in 7.3
Posted in 1998
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. Art S. Kagel