Re: indexes and extents

hkchan@idt.com wrote: > > hi, > > I am using informix 7.13.UC2 on an hpux 10.01. I have created 4 > indexes in a separate dbspace for this huge table that I have. What I > have found is that when I used the 'create index idxname on > tblname(col1) in dbspace', i found that the index has an entry in the > smi tables. > > I could not control the extent size when I created the index, unlike > creating table, and these indexes have quite a number of extents to > them. > > Is there a way of giving the index an initial extent size, and > prevent or reduce the number of extents on that particular index. > The first / next extent size of the index is dependent on the first / extent size of the table. To my knowledge, there is no way to reset extent sizes on detached indices. John Carlson WH Smith, Inc.