Re: De-fragmenting a table

Carlson, What values did you set for the PDQ parameters, which made index build run faster? Vinod Bhansali >HPL is great. I've used it to handle various large tables and it works >wonderfully, but I only use it for tables unload / reloads. I still >rebuild the indices AFTER the load is complete. > >Are your indices detached? (I believe that the default Lawson table >structure detaches the indices.) One thing I've found out is that >creating a detached index takes quite a bit longer than creating an >attached index. Somehow Informix isn't taking advantage of multiple >sort threads; all I see in onstat -g ses are exchange threads. Enabling >PDQ took a 4 1/2 hour index build down to 45 minutes, which was >comparable to the 'old' way of creating attached indices. > >BTW, Which Lawson table is it? > > >-- >John Carlson >Informix DBA >WHSmith USA > >#include std_disclaimer.h /* These are my opinions, not my company's >opinion */ ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com