Re: Slow index builds

Thanks for the reply David. >How many unique values are there in column bar2? 1.31 million of the 6.69 million values in bar1 are unique 2.48 " " " " " " bar2 " " So, perhaps it is the extra length of bar2 which is slowing down the duplicate list-build drastically. Does Online handle CHAR(8) specially? Or is it because I'm running out of efficient tempspace when building the index for the larger column which isn't happening for the smaller one? What does 4.10 use as tempspace when building indices if it needs any? DBTEMP is pointing to /var/tmp which has only half a gig free. I know 4.10 is rather long in the tooth and there are lots of reasons (this ineffient way of building indices now added to them) why I plan to upgrade as soon as possible. I.e. as soon as Informix gets its act together and releases a Linux port.