Re: Query Optimization ... Is this all I can get??

The reason your original solution didn't work well is that You needed to have the correct indexes, which you have added and then the outer join query should be better and faster. > Although your first option would work in my case, it would be a mess, > as they would have to be OUTER joins of the address and phone table, > and the joining of some 100K with 300K with another 150K takes some > time [although, this was my original solution]. >