Detached indices in 7.3
Posted in 1998
W. H. SMITH — — source: Informix-list mailing list archive (1991-1998)
Informix 7.23.UC4 HPUX 10.01 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? John Carlson Informix DBA WH Smith, Inc.