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