Subject | Re: [firebird-support] Indexe's on Keys |
---|---|
Author | Nando Dessena |
Post date | 2004-03-23T07:06Z |
Helen,
H> Just that if your PK and your FK indexes are in opposite sort
H> orders, one index can't be used to find the other in joins, validation
H> searches, etc., so performance would be slowed.
this doesn't make a lot of sense to me but I guess there are more
things in heaven and earth etc... Another thing to pay attention
to while we are stuck with these dumb unidirectional indexes, I guess.
:-)
Thank you.
--
Nando Dessena
mailto:nandod@...
H> Just that if your PK and your FK indexes are in opposite sort
H> orders, one index can't be used to find the other in joins, validation
H> searches, etc., so performance would be slowed.
this doesn't make a lot of sense to me but I guess there are more
things in heaven and earth etc... Another thing to pay attention
to while we are stuck with these dumb unidirectional indexes, I guess.
:-)
Thank you.
--
Nando Dessena
mailto:nandod@...