Subject Re: [IB-Architect] Fw: Sql Speed - Interbase using Foreign Key index , not the 'regular' index
Author Jim Starkey
At 09:02 PM 4/1/00 -0400, you wrote:
>Hello, I think this is one to read... but only for people with enough time
>to spend. I prefer the explicit join syntax but the point is: a foreign key
>makes IB pick the wrong index. I suggested changing a condition of the form
>tableA.field = tableB.field
>that uses the wrong index to be rewritten as
>not tableA.field <> tableB.field
>so it gets no priority from the optimizer.

I don't know where you got the idea that the optimizer knows or
cares about foreign keys. It doesn't. All it knows about are
indices and whether or not they are unique.

Jim Starkey