Hi All,

I have 2 tables which has 10 Million records and defined Primary Keys.

I need best approach and which will be the fastest process.

1) Create all required Indexes on both tables and then create Foreign
Keys.
OR
2) Create Foreign Keys and then create all required indexes on it.

Thanks,Prashant

Personally I go for the former, I like to name indices myself, allows me
to scripts things a lot easier

Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457

GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend the IDUG 2006 North America Conference.
Tampa, Florida, USA. 7-11 May 2006.
Visit http://www.iiug.org/conf for more information.



> -----Original Message-----
> From: Prashant Shirude [mailto:PShirude@manh.com]
> Posted At: Friday, March 03, 2006 10:22 AM
> Posted To: comp.databases.informix
> Conversation: Need suggestion on Foreign Keys
> Subject: Need suggestion on Foreign Keys
>
>
> Hi All,
>
> I have 2 tables which has 10 Million records and defined Primary Keys.
>
> I need best approach and which will be the fastest process.
>
> 1) Create all required Indexes on both tables and then create Foreign
> Keys.
> OR
> 2) Create Foreign Keys and then create all required indexes on it.
>
> Thanks,Prashant