>>>Without the index on the field engaged in the join condition you probably would not get speed increase.
>>
>>Your message was very insightful for me, espescially how an left outer join works. I didn't know that the where clause was destroying this, after all I just needed an inner join which runs very fast now.
>
>You're welcome. You probably may want to mark helpful messages.
Yes, I was planning to do so:).