Subject Re: [ib-support] Re: Helen: Low Selectivity Problem
Author Woody
From: "Alan McDonald" <alan@...>
> I might jump in here...
> I do not use foreign keys at all in my databases!
> ooooh I hear frowns and tisk tisks here....
> but nonetheless, my triggers do all the work for me. They also provide a
> more comfortable environment to develop in.

I do the same thing. I find changing criteria easier when you maintain
things like that manually. It's much easier to change a procedure or trigger
than to change foreign keys and referential integrity constraints. At least,
it seems like it for me. <g>

I think it also makes things easier to port to different types of databases
as well since not all of them support RI with foreign keys.

Oh well, enough of this before heLen's pointy hat is donned and the
discussion is booted to a more relevant environment. <g>

Woody (TMW)

"To invent, you need a good imagination and a pile of junk."
Thomas Edison