Dear all expertist,
Right now we found out that one SQL SP is running good on test/QA platform but not on production, may I know what can cause this?
I knew that different:
can cause this, what else ?
I think I need to update statistics at the first step to see if it helps.
I don't want to go for a hard way.