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 ?
>

1. As for any RDBMS, catalog tables serve the purpose. So, tables such as
systables, store the table information for the database, syscolumns store
the
column info for each table, sysindexes store indexes for each table,
sysconstraints constraints .. and so on and so forth.

2. I'm not getting this ..? if you don't create the indexes how's it going
to be disabled or enabled ? Update stats work with or without indexes.. if
you have
indexes on tables then it'll have better information on the column
values and can make the access faster by choosing a plan which is least
costly if its got
good information.

HTH

Rajib Sarkar
Sr. Technical Analyst
DB2 RPD Team ( Level 3 Support )



HTH