Re: One-To-One Relationships
Date: Wed, 21 Nov 2007 20:19:03 -0000
"Dr. Dweeb" <spam_at_dweeb.net> wrote in message
> 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