Re: One-To-One Relationships

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

"Dr. Dweeb" <spam_at_dweeb.net> wrote in message news:4743ddaf$0$21929$157c6196_at_dreader1.cybercity.dk...
> 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 - 14:19:03 CST