Re: Indexing speed

Posted in 1998

Steve Romankiw — Thu, 05 Nov 1998 13:10:23 -0500 — source: Informix-list mailing list archive (1991-1998)

A couple of things to try: o Fragment the table to increase the number of scan threads o Turn off KAIO (onconfig setting KAIOFF=1) and increase AIOvps Steve Romankiw Bottoms, Douglas A (Doug) wrote: > We are running Solaris 2.6, Informix online 7.24.UC5. > We have set the following: > > MAX_PDQPRIORITY 100 > FILLFACTOR 90> > We are creating 3 composite indexes on a table with over a million rows and > it takes appx 1 hour. Are there any suggestions on improving performance ? > > Thanks in Advance > > Doug Bottoms