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.

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