RE: Informix Indexes - Help

I don't understand... How do you migrate an index? You migrate your data and then "rebuild" your indexes on your *new* database server... IDS 9.4 to O9i??? Did you help make this decision? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Harish Vamsi Mohan via DBMonster.com Sent: Wednesday, April 13, 2005 3:32 AM To: informix-list@iiug.org Subject: Informix Indexes - Help 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 sending to informix-list