Re: Detached indices in 7.3

SaTriGuy wrote: . . .snip . . . > I think this is a rumor only. I just ran a quick test on my 7.3 engine and my > indexes were attached. > Even when you create a new index? Good. > Even so - I would not worry about detached/attached indexes. If this is > implemented like it is in 9.x, then the indexes will be created as detached, > but existing attached indexes will be functional. There is a performance > 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? Thanks in advance for the patience. This is a relatively new area that I'm wanting to explore, when I'm not in the middle of development. I know that there is more to OnLine then what I'm using; I just want to be able to expand my knowledge in order to create a more efficient system. John Carlson Informix DBA WH Smith, Inc.