Subject Re: Poor selectivity in foreign keys
Author johnmancuk
You could still have potential problems, if you're using multiple
simultanious transactions.

TABLE STABILITY transaction isolation will ensure only one trans is
using the table at once. Either use that, or use indexes, to be


--- In, "Salvatore Besso"
<s.besso@m...> wrote:
> hello all,
> after having read all your replies, I still wonder if I can keep
the SP's for
> cascaded deletes. Maybe I forgot to say that this application is
using FB
> embedded and is single user, no network.
> Maybe if I would develop another networked application I'll keep
FK indexes even
> if they slow down the application. What do you think about?
> Regards
> Salvatore