Re: One-To-One Relationships

From: Roy Hann <specially_at_processed.almost.meat>
Date: Wed, 21 Nov 2007 20:19:03 -0000
Message-ID: <>

"Dr. Dweeb" <> wrote in message news:4743ddaf$0$21929$
> Roy Hann wrote:

> Doh - thats why optimizers support index-only scan retrieval
> optimizations. The correct solution to your example is almost invariably
> to have an index on the two columns and let the optimizer figure it out.
> That is the whole point of having one

I completely agree with you.

Roy Received on Wed Nov 21 2007 - 21:19:03 CET

Original text of this message