I was trying to avoid a lengthy discussion, but I guess nobody else is
jumping in.

I think what you are asking is whether it is better to disable an index,
load a bunch of data, and then enable the index. The answer is, of course,
that it depends. If you are going to push a lot of data into the table,
then it will be quicker to re-create the index. If we are talking one or
two rows, then what is the point of disabling the index?

Your update statistics question is unclear. Having an index will not
improve the performance of update statistics. The guidelines call for
updating statistics high on columns which are indexed. I would check out
ak_util from the iiug site for a guide from the master on this topic.

Cheetah has a feature where statistics are gathered while the index is being
created, thus obviating the need to update stats after the index creation.

j.

-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]On Behalf Of
mohitanchlia@gmail.com
Sent: Monday, June 18, 2007 8:27 PM
To: informix-list@iiug.org
Subject: create indexes vs enable indexes


if somebody could throw some light, if creating indexes are better
than enabling indexes. Also does update stats work better with
creating
indexes or when indexes are enabled.

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list