Mike (4/1/2009)

---

Glad to hear it all worked out and was beneficial for you. Always a good feeling to see those queries drop from minutes to under a second,...

Mike (3/25/2009)

---

Given the code you have here (I am copying it in for my own reference)

SELECT

M.Surname,

M.GivenName,

A.StreetNumber,

...

Thanks Mike. I'll try out your suggestion tomorrow and will get back to you.

Since I got them, I might as well post some of my test results:

Clustered Index on MemberID, index on StreetNumber, index on StreetName

Execution Plan: select, nested loop, index seek on...

How many ways can you skin a cat? I've been testing the join with a number of different index combinations and I haven't found a clear cut winner. I have...

Mike, thanks for all of your help. You'll see below that we're on the right track!

You may want to check on the IO's for these queries to get a better...

I have another example that demonstrates this issue. Take the following query:

SELECT

M.Surname,

M.GivenName,

A.StreetName

FROM

Member AS M

...

Thanks for your response Mike.

I tried this and ran it again. The execution plan remains unchanged....