Subject | HELP ! Adding a foreign key SLOWS down query |
---|---|
Author | Amrita Chaudhury |
Post date | 2002-08-06T20:30:18Z |
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]
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]