DDL or DML scripts AND enable vs create index

Posted in 2007

mohitanchlia@gmail.com — Sun, 17 Jun 2007 12:35:23 -0700 — source: Usenet: comp.databases.informix

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 ?

↪ replying to mohitanchlia@gmail.com

Jack Parker — Sun, 17 Jun 2007 16:13:25 -0400 — source: Usenet: comp.databases.informix

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