Subject HELP ! Adding a foreign key SLOWS down query
Author Amrita Chaudhury
HI,

I had a set of stored procedures that were used to join and query certain
data tables, and
all was working fine, till I had to add foreign key reference on one of the
columns on these
tables to a column in another configuration table.

If I take off the feriegn key reference, everything is ok, as soon as I put
it back on, the
query just never makes it through ..


PLEASE help .. I do need to reference this to the other table - how can I
get away with
this ?

In deep distress,

Regards ! and TIA,

AC


[Non-text portions of this message have been removed]