Re: Detached indices in 7.3

Andreas Zeugswetter wrote: > > 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. > This is true; there would be no difference between current 7.2x and 7.3. But when your database has 400+ tables with associated indices, then administration could be fun. Data and index extents for a table would get to play leapfrog with other data and index extents for other tables within the same dbspace. I'm just wondering if they (detached indices) are required under 7.3x. > > 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. John Carlson Informix DBA WH Smith, Inc.