Ok, I think there is where I had the misconception; I did not how how to create an effective index for a query with both a JOIN and WHERE statement,...
@GilaMonster - Thanks for the reply and links. I actually read those links in the past and went through them again (specifically the column ordering part) but I am...