Re: Indexing speed

A couple of suggestions. For one, try playing with different values for PSORT_NPROCS. A value of 2 or 3 usually works pretty well for us. Another, create the indexes in dbspaces other than the one containing the table, preferably on a separate physical disk. That should help eliminate some disk contention. And, if you don't already have them, create a couple of temporary dbspaces, again on separate disks if possible. Informix will use temporary spaces for the sorts necessary to build the indexes, and this is faster than using file system space or root space. HTH, - Tom Girsch Database Systems Manager Arch Communications Group Bottoms, Douglas A (Doug) wrote in message <71pk0s$jhm$1@news.xmission.com>... > > >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