Re: Detached indices in 7.3

>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. Madison Pruet