Re: Detached indices in 7.3

>> benifit by having detached indexes inplace of attached indexes (i.e. data >scans >> do not have to "skip" pages), and the total space required should be >identical. >> > >It seems to me that the data could become quite fragmented across a >dbspace due to the other tables within said dbspace. 400 tables and >1000 indices. How would the engine handle that? > Actually right the opposite occurs. When an index is attached to the data partition, then the index and data pages are randomly interspersed. With a detached index, the index extent has it's own extent list. This is no problem for the engine. > >John Carlson >Informix DBA >WH Smith, Inc. Madison Pruet