I have a stored proc that runs about 40 seconds, while the same code in QA runs in 2 seconds. The execution statistics show millions of logical reads in the sp, but very few in the QA version. There is one parameter input and one temp table in the code. How can I make what seems like a bad execution plan in the sp run like the one that QA came up with? I can post the code if needed. Running SQL7 on an NT box.