Attached vs. Detached index

Posted in 2001

Topics: Versions, Editions & End-of-Life

Bogdan Neagu — Wed, 10 Jan 2001 11:00:58 -0500 — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Bogdan Neagu

Art S. Kagel — Tue, 06 Feb 2001 23:04:30 -0500 — source: Informix-list mailing list archive (1991-1998)

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

Glossary

IDS (Informix Dynamic Server)