Re: Detached indices in 7.3

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. >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