Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Mark D. Stock — — source: Usenet: comp.databases.informix
miyaki wrote:
> Which option is better and faster in term of
> performance, if I want to rebuild the huge table?
They are both the same in terms of performance. Disabling and enabling
indexes is just easier than dropping them completely and having to
remember what they were, in order to recreate them. Nothing to do with
build performance.
If you are trying to improve index build performance, then you should be
setting environment variables like PDQPRIORITY and PSORT_NPROCS.
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+
sending to informix-list
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.