Re: Indexing speed

In article <3641d25200000001@news.harland.net-MINC>, Barry Leb <bleb@harland.net> writes >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. > Archiving - it create temp tables to store physical log entries so it can get a consistent image of the database. Before (7.24??) it would not fragment the table round robin around the temp dbspaces. It would all go in the first one and when that filed up the archive would fail.. > >"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 > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care