Re: Relation problem

Michel wrote:
>
> First clarification:
> The primary problem is performance between addresses and (Organizations OR
> Individuals).
> Individuals and Organizations can have more than 1 address.
> An address can exist by itself.
>
> So, there will be addresses in the address table that are not assigned to
> anybody, but Individuals or Organization do require and Address.

Ah. That certainly clarifies a few things. So the problem is that you have a foreign key that ends in a strict subset of a primary key, and are not happy with the performance of that. Did you check if you can define a separate index on that subset?

-- 
  Jan Hidders