As long as you have tag on ResNum, your chances to improve it even more are slim; though you could still try to split it on two Selects and see what is faster.

>I already had the IN clause in my select. I was hoping to improve performance
>by using a JOIN.
>
>
>>>Yes, this Select should be splitted on two, the first one will do Select Distinct ... Into Cursor..., and next one will join the cursor.
>>
>>Not necessaraly. You can do the same if you move JOIN into where condition like
>>

>>where ResNum in (select distinct ResNum from ...)