RE: DDL or DML scripts AND enable vs create index

If you need more detail, try the the create_idx function in dbdiff2. It gets all of it's information from the system catalogues - just as dbschema does. http://www.iiug.org/software/archive/dbdiff2 j. -----Original Message----- From: Mohit Anchlia [mailto:mohitanchlia@gmail.com] Sent: Sunday, June 17, 2007 11:46 PM To: Jack Parker; informix-list@iiug.org Subject: Re: DDL or DML scripts AND enable vs create index But how do I get the complete index's script. For eg: dbschema gives "create index asssa" script, how do I get this from the database directly. I see that you could retrieve procedure for sysprocbody table, but how do I get the indexes. Also if somebody could throw some light on if creating indexes are better than enabling indexes. Also does update stats work better with creating indexes or when indexes are enabled. On 6/17/07, Jack Parker <jack.parker4@verizon.net> wrote: Here's a little article that should answer your first question. http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/030 5parker/0305parker.html I'm not touching the second one. j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto: informix-list-bounces@iiug.org]On Behalf Of mohitanchlia@gmail.com Sent: Sunday, June 17, 2007 3:35 PM To: informix-list@iiug.org Subject: DDL or DML scripts AND enable vs create index 1. I just want to know if informix store create index or alter table type of scripts in some table. I am assuming that informix stores them in tables otherwise how would dbschema get these ? Could you please let me know. 2. Also which is better enable indexes or create indexes. Does update stats work better on create indexes ? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list