August 22, 2011 at 10:25 am
GilaMonster (8/22/2011)
Ninja's_RGR'us (8/22/2011)
GilaMonster (8/22/2011)
Ninja's_RGR'us (8/22/2011)
P.S. when something runs 10X slower than something else, the plan is NOT the same... or should not be the same.Unless there's major blocking/waits on the slow one.
But this is guessing, without some data it's going to remain a guess.
Agreed, but we'd still see that in the actual plans :-D.
Errr... See waits and blocks from the execution plan (actual or estimated)????
Compare both slow and fast actual plan. If they are truly identical in absolutely every aspect then the problem could be assumed outside the query. Still just a good guesstimate at best tho.
August 22, 2011 at 12:41 pm
Lucky9 (8/22/2011)
Oh ok, But am sorry i cannot even post the execution plan....But i see execution plan is same
Why? It doesn't reveal any data (except perhaps in a where clause ...), nor does it reveal enough info for us to steal your database design.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply