Create index VS Set Index Enabled - IDS 7.31

[Stéphane Gadoury]

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.

Any comments are welcome !!!

Thks !

Stephane

sending to informix-list

[Mark D. Stock]

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 [url]http://MydasSolutions.com[/url] |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+

sending to informix-list

[miyaki]

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
> [url]http://MydasSolutions.com[/url] |///// / //|
> |
> +-----------------------------------+//// / ///|
> | |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!
[url]http://sbc.yahoo.com[/url]
sending to informix-list