Re: Enabling/Disabling an Index Revisited

This is a multi-part message in MIME format. --------------9104F1E2AC9BC5464D710E7E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Thanks for the help. Regards, Jojo "Mark D. Stock" wrote: > > Eduardo MORALES wrote: > > > > Hi Gurus, > > > > I need your second opinion on using the SET INDEXES..<ENABLE/DISABLE>, > > Will it rebuild my indexes ? > > The ENABLE option will rebuild the index. > > > Any environment variable need to be set to > > speed up rebuilding of index like PSORT, etc.. ? > > Yes, if you have a multi CPU platform, then PSORT_NPROCS, PDQPRIORITY > and even PSORT_DBTEMP are useful. > > Cheers, > -- > Mark. > > +----------------------------------------------------------+-----------+ > | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| > | http://www.informix.com http://www.informixhandbook.com |///// / //| > | http://www.iiug.org +-----------------------------------+//// / ///| > | |This email will self-destruct in |/// / ////| > | |10 sec. If you received this email |// / /////| > | |in error, sorry about the mess. |/ ////////| > +----------------------+-----------------------------------+-----------+ --------------9104F1E2AC9BC5464D710E7E Content-Type: text/x-vcard; charset=us-ascii; name="ejmorale.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Jojo Morales Content-Disposition: attachment; filename="ejmorale.vcf" begin:vcard n:Morales;Jojo tel;work:830-58-40/42 x-mozilla-html:FALSE org:DHL Aviation Phils.;APME-OPS IT Development version:2.1 email;internet:ejmorale@apme-ops.dhl.com title:IT Contractual Developer note:/* These are my opinions, not my company's opinion */ adr;quoted-printable:;;12/F Urban Bank Plaza=0D=0APasong Tamo cor. Buendia;Makati;;;Phils. fn:Jojo Morales end:vcard --------------9104F1E2AC9BC5464D710E7E--