Sorry, should have looked at the plan closer. The QA query executed once and the sp executed 101 times. A clustered index seek and scan executed 101 times for both....

Thanks for the quick response. The sp ran about the same using the WITH RECOMPILE option. I compared the plans and found that the Table scan was 97% of the...