Re: Create index VS Set Index Enabled - IDS 7.31

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