Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Fernando Nunes — — source: Usenet: comp.databases.informix
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...
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.