Re: Detached indices in 7.3

In article <34E9DAB1.2EE6@bellsouth.net>, John Carlson <carlson1@bellsouth.net> writes >David Williams wrote: >> >> I >> >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? >> > >> >> You should create table with the correct initial extent size up front. >> > >And the index initial size . . . <G> ? > There is no initial size, it is calculated from the initial table size and the ratio between table row size and index key size. > >John Carlson >Informix DBA >WH Smith, Inc. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care