Which option is better and faster in term of
performance, if I want to rebuild the huge table?

--- "Mark D. Stock" <mdstock@MydasSolutions.com>
wrote:
> Stéphane Gadoury wrote:
> > Hi List,
> >
> > I am in the process of re-doing my production DB.
> >
> > One of the step I decide to perform was to "Set
> index enabled" instead of of
> > re-creating them from scratch.
> >
> > So my question is: Is set index enabled exactly
> the same as the create
> > index.
>
> Not entirely. You have to create your indexes first,
> using the CREATE
> INDEX command. You can create indexes that are
> disabled, and then enable
> them later using the SET INDEXES command. Enabling
> an index will
> effectively rebuild the entire index.
>
> > Any comments are welcome !!!
>
> I wouldn't tempt OTC like that. ;-)
>
> 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


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
sending to informix-list