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". J. Dority > > John Carlson > Informix DBA > WH Smith, Inc.