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. > >Could it be LAWSON? > >> 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. > > >7.3 Won't support attached indices? That seems a bit far-fetched. >"Lets chop off our install base at the knees". > >> >> 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 ran into this problem with Lawson. Since the indicies are detatched, >separate extents are allocated for indexes. This ate up our disk >space in a hurry. > >After digging around in Lawson, we finally saw that it was >using the "in dbspace" clause by default when it built indexes >regardless of whether you used their configuration tables to "truely >request" a detached index. I think they need to change their >dictionary tool. I ended up dropping all indexes, and recreating them >without the "in dbspace clause". I think this is simply a rumor. I just ran a quick test on 7.3 and my indexes were attached. Also, if the indexes are detached, they should not take any more space than they currently do, unless a rather large initial extent is declared for the index. > >J. Dority > > >> >> John Carlson >> Informix DBA >> WH Smith, Inc. Madison Pruet