A stored procedure executed on SS7 SP2 completed in approx. 5mins.
Following an upgrade to SP3 the same proc. completed in approx. 55mins. !! (Same server, same db, yada, yada, yada)
i) Could the QEP have changed ?
ii) Is there any means by which one can guarantee that a stored procedure uses the same QEP as generated by the QA ?
If so - how can one tell ?
iii) Could sp_recompile be of any benefit ?
Thanks In Advance