Informix Indexes - Help

Posted in 2005

Harish Vamsi Mohan via DBMonster.com — Wed, 13 Apr 2005 08:32:24 GMT — source: Usenet: comp.databases.informix

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>. Appreciate any help on this issue. Thanks Regards, Vamsi Mohan Harish -- Message posted via http://www.dbmonster.com