indexes and extents
Posted in 1997
hkchan@idt.com — — source: Informix-list mailing list archive (1991-1998)
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. thanks, - HK Chan (408-953-2526) Thought for the day: Bagpipes (n): an octopus wearing a kilt.