Shishir,
If there are only a few records in the table, very little. However, if the table is nicely populated, it can make a tremendous difference. You could always do a little testing to find out in your particular case, but I wouldn't bother. I ALWAYS index foreign keys.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Shishir Kumar Mishra [SMTP:[EMAIL PROTECTED]]
Hi Gurus!
How does the unindexed foreign key affect the performance ?
regards....
Shishir Kumar Mishra
Agni Software (P) Ltd.
www.agnisoft.com <http://www.agnisoft.com>
----------------------------------
Vidya Dadaati Viniyam
----------------------------------