Re: Enabling/Disabling an Index Revisited

Posted in 2000

Mark D. Stock — Wed, 09 Aug 2000 23:32:19 +0100 — source: Informix-list mailing list archive (1991-1998)

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. |/ ////////| +----------------------+-----------------------------------+-----------+