Re: Informix Indexes - Help

Harish Vamsi Mohan via DBMonster.com wrote: > Hello, > > We are migrating Informix 9.4 to Oracle 9i database. We are facing an issue > with the Indexes on the Informix. When a Primary or a Foreign Key (for > which an Index is created implicitly on Informix) is dropped, will the > Indexes will also get deleted automatically? > > Because, when we verified and validated the Indexes after migration, we > have found some instances where the system generated index is present on a > Column in Informix which is neither a Primary key nor a Foreign Key. And > those Indexes are not migrated. > > Also, we need to know why these system indexes are created(its neither > related to primary key constraint nor foreign key constraint). > > To our understanding, System generated Indexes are of the syntax > <TabID>_<ColID>. IDS also generates such indexes for UNIQUE constraints. If dbschema or myschema reports that the table has a unique constraint that is likely the unidentified index. FYI, you can find out what constraint the index belongs to thus: select t.tabname, c.* from sysconstraints c, sysindexes si, systables t where si.tabid = t.tabid and si.idxname = c.idxname and c.idxname = " 123_33"; The constrtype column will tell you what kind of constraint it is. Art S. Kagel > Appreciate any help on this issue. > > Thanks > > Regards, > Vamsi Mohan Harish >