Execution Plans

  • nigel.meakins

    SSC Veteran

    Points: 220

    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: 166

    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

    Really a great explanation.Thak you vjy

    Kartheek Anumolu

  • AK1516

    SSCrazy

    Points: 2705

    Really a great explanation.Thak you vjy

    Kartheek Anumolu

  • bharathi8179

    SSC Enthusiast

    Points: 122

    Very nice article.

  • Robert Purnell

    SSC Journeyman

    Points: 85

    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.

  • komathi.radhakrishnan

    Valued Member

    Points: 71

    Nice article :). Thank you for explaining with examples

  • ranjan.singha

    Valued Member

    Points: 67

    Nice article.

  • kysphaneendra

    SSC Enthusiast

    Points: 182

    Good to Read,

    Its like a story for me to read

    English may not be a serious issue.

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

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