RE: Attached vs. Detached index

Posted in 2001

Parker, Jack — Wed, 7 Feb 2001 11:31:44 -0500 — source: Informix-list mailing list archive (1991-1998)

Not precisely true. You can set an environment variable DEFAULT_ATTACH=1 which forces declared indices to be attached unless a fragmentation scheme is included. Doesn't work for PK/FK. cheers j. > -----Original Message----- > From: Art S. Kagel [mailto:kagel@erols.com] > Sent: Tuesday, February 06, 2001 11:05 PM > To: informix-list@iiug.org > Subject: Re: Attached vs. Detached index > > > All indexes in 9.2x are detached unless they were inherited > from a 7.3x > server that was upgraded in place and the index was not rebuilt > afterward. > > Art S. Kagel > > Bogdan Neagu wrote: > > > > Hi all. > > > > In IDS 9.21 (FC2), how can I determine if an index was > created attached > > or detached ? > > > > What are the pros and cons for attached vs. detached ? > > > > Thanks in advance, > > > > Bogdan Neagu >