Hi! I have a join which looks something like this: SELECT ... FROM @memberselection t INNER JOIN order o ON o.member_id = t.member_id INNER JOIN transactions t ON t.order_id = o.order_id For a large set in @memberselection this takes forever. For a selection of about 1000 members, it takes 30 second...