Post reply

Undestanding Execution plan

  • May 24, 2006 at 2:34 pm

    #168501

    I´m trying to understanf Execution plan, I´ve ready looked up at books online but nothings clears, it only shows what icons are showed and some information about them, but no what kinf of values are best or worst.

    For example I have this query

    Select A.CB_PRODREES,CB_DESC_PROD_REES 

    from PS_CB_EMICONVENIOS A, PS_CB_TIPO_PROD_RE B

    where A.NUMERO_CREDITO = '0500012556'

    AND A.CB_AUTORIZADO = 'Y'

    AND A.CB_PRODREES = B.CB_PRODREES

     

    Trying to be more explicit, how can I know that the sentence is right, and dont have performace problem?

    I´ve saw in other sentences that an index clusteres seek cost 50%, on others 100%, or a index scan cost 40%, somethings like that, what value is the best, or how can I know that a sentence has no performance problems

     

    Thanks for any guide.

  • May 24, 2006 at 5:07 pm

    #639927

    Have a look at this article:

    http://www.sqlservercentral.com/columnists/jsack/sevenshowplanredflags.asp

  • May 25, 2006 at 6:53 am

    #640016

    If you're interested in purchasing a book...

    Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook by Ken England does a good job of explaining the estimated execution plans, showplan text, etc. as well as a lot of index tuning info.

Viewing 3 posts - 1 through 2 (of 2 total)

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