Re: Indexing speed

What are you temp spaces like? I have found that more smaller temp spaces vs fewer larger ones improve index build performance. However, there is a tradeoff There are some Informix operations that can only use a single temp dbspace.(Unfortunately, I can't recall what they are at this time). In this situation it is best to have the largest temp dbspace you can configure - 2gig. "Bottoms, Douglas A (Doug)" <dbottoms@lucent.com> 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 Barry Leb Sr DBA Information Technology Division Harland 2939 Miller Road Decatur, GA 30035 Phone: (770) 593-5050 x6137 Fax: (770) 593-5420 email: bleb@harland.net