Re: Index Fragmentation strategy

In article <35BC9F52.36811D0E@telecom.at>, Andreas Zeugswetter <andreas.zeugswetter@telecom.at> writes >There is an additional problem with Indexes in their own dbspace if you: > > alter table tablename next size 500;> >Then the index next size is not recalculated but set to 500 too, this results in >way too big >index extents. > Even on 7.24/7.30 ?? >Andreas Zeugswetter > > -- 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