Thanks for the replies. I tried using a join instead of a sub-query, but I got the same execution plan. I am posting the statements from the actual stored proc....