Execution Plans

Question

Execution Plans

Viewing 9 posts - 46 through 53 (of 53 total)

You must be logged in to reply to this topic. Login to reply

nigel.meakins SSC Veteran Points: 220 More actions · Answer 1

I actually think Phoqueme has some valid points regarding the quality of the article and the need to be succinct. Okay, doing a SoundEx on his name may be a little sad, but not anywhere near as sadly pretentious as all that 'first steps to the set based thinking shift' and 'Rebar' twaddle. I mean, where did that RBAR term come from anyway? Someone banging on about how bad cursors are, for the umpteenth time no doubt.

Oh to be a SSC champion... perchance to dream.

proactiveamit SSC Enthusiast Points: 196 More actions · Answer 2

I would like to know why non-clustered index on three or more columns does not work even when the columns are put in the same order as in the index and instead of that clustered index scan is called in the Execution plan.

I found through search that Non clustered index is not called because my where clause was not enough selective but what if I need more data and retrieval should be fast.

AK1516 SSCrazy Points: 2705 More actions · Answer 3

Really a great explanation.Thak you vjy

Kartheek Anumolu

AK1516 SSCrazy Points: 2705 More actions · Answer 4

Really a great explanation.Thak you vjy

Kartheek Anumolu

bharathi8179 SSC Enthusiast Points: 122 More actions · Answer 5

bharathi8179

SSC Enthusiast

Points: 122

May 15, 2010 at 8:26 am

#1167928

Very nice article.

Robert Purnell SSC Journeyman Points: 85 More actions · Answer 6

Good basic introduction to execution plans and optimisation but poor English really lets this article down. In many places the real message is lost by poor explanation. Simple and clear communication is hindered by incorrect English and over laboured expressions. This article should be edited by someone with better English skills to help with clarity.

Otherwise, good job.