Re: DDL or DML scripts AND enable vs create index

mohitanchlia@gmail.com wrote: > 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 ? > Enabling an index is similar to create a new one. Disable indexes have the advantage of appearing in the schema... But to be honest I don't find them very useful... Update statistics may or may not be influenced by this... To be honest I don't know, but I assume that LOW stats are not collected for disabled indexes... Itsimply doesn't make sense, since these indexes are never used... If I didn't catch your idea completely please insist. Regards, -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...