Re: Detached indices in 7.3
Posted in 1998
How that ? The detached index would automatically land in the same dbspace (fragments) as the table, same as fragmented tables in >=7.0 already behave. > 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? > > John Carlson > Informix DBA > WH Smith, Inc.