Post reply

Table Access Order

  • September 20, 2011 at 7:56 am

    #1383858

    Nice question, thanks!

  • September 20, 2011 at 9:00 am

    #1383898

    It's been good getting some of these harder questions that require knowing how SQL works. Thanks for taking the time to put them together.

  • September 20, 2011 at 9:40 am

    #1383930

    I was expecting to see "undetermined, could be either" as an option so guessed (wrongly as usual).

    Learned something new - not sure how useful it is to know, but these things are always interesting 🙂

  • September 20, 2011 at 9:43 am

    #1383934

    Got it wrong 🙁

    Thanks for the question, eventhough I got it wrong I learned something. Great explanation!

    ---------------------------------------------------------------------
    Use Full Links:
    KB Article from Microsoft on how to ask a question on a Forum

  • September 20, 2011 at 9:53 am

    #1383948

    Toreador (9/20/2011)

    Learned something new - not sure how useful it is to know, but these things are always interesting 🙂

    It depends. The average DBA can get by perfectly well with just a basic understanding of execution plans.

    But who wants to be average?

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • September 20, 2011 at 10:53 am

    #1384010

    great question

  • September 20, 2011 at 10:57 am

    #1384012

    SQL Kiwi (9/20/2011)

    Toreador (9/20/2011)

    Learned something new - not sure how useful it is to know, but these things are always interesting 🙂

    It depends. The average DBA can get by perfectly well with just a basic understanding of execution plans.

    But who wants to be average?

    Who works hard enough to be exceptional?

    Enough said :hehe:.

  • September 20, 2011 at 10:22 pm

    #1384309

    Nice question and learnt something!

  • September 21, 2011 at 3:23 am

    #1384376

    Excellent question, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 21, 2011 at 4:00 am

    #1384389

    SQL Kiwi (9/20/2011)

    But who wants to be average?

    I dream of being average, but have quite a way to go still to achieve it 🙂

  • September 21, 2011 at 6:55 am

    #1384456

    Great question, Paul. It is always a good thing to know what is going on under the hood.

    Thanks,

    Matt

  • September 22, 2011 at 2:52 pm

    #1385460

    Thank you for such an amazing question, Paul.

    I got it right because I always remember reading that the "top (outer) input" is read first and then it goes look for matches in the "bottom (inner) input". Even the Nest Loops operator works this way, right?

    I just started reading the excellent Execution Plan book from Grant Fritchey.

    It was a nice timing for me. 🙂

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • September 23, 2011 at 12:06 am

    #1385534

    codebyo (9/22/2011)

    I got it right because I always remember reading that the "top (outer) input" is read first and then it goes look for matches in the "bottom (inner) input". Even the Nest Loops operator works this way, right?

    Right. 🙂

    http://sqlblog.com/blogs/paul_white/archive/2010/08/05/iterators-query-plans-and-why-they-run-backwards.aspx

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • September 23, 2011 at 7:52 pm

    #1386077

    SQL Kiwi (9/23/2011)

    http://sqlblog.com/blogs/paul_white/archive/2010/08/05/iterators-query-plans-and-why-they-run-backwards.aspx

    I have been following your blog for some time now but I hadn't found that article before. I have much to learn and I appreciate those links.

    Can I print that article for my personal use and to show it to my workmates?

    I'm trying to help them understand the basics of the execution plans and they get confused about the order of what's happening and why. I'm performing basic training about this subject to help them improve their queries which are very slow.

    Today I was confronted with an old code that joined 20 tables and then had a cursor to manage that. We successfully replace that code and improved what was once running in almost 10 minutes to 50 seconds. It still isn't optimized enough but we'll soon get there.

    Thank you for the amazing articles you post.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • September 23, 2011 at 10:47 pm

    #1386085

    codebyo (9/23/2011)

    SQL Kiwi (9/23/2011)

    http://sqlblog.com/blogs/paul_white/archive/2010/08/05/iterators-query-plans-and-why-they-run-backwards.aspx

    I have been following your blog for some time now but I hadn't found that article before. I have much to learn and I appreciate those links. Can I print that article for my personal use and to show it to my workmates?

    Well thanks, I wondered who the other reader was 🙂

    Of course you may print it and show it around, I only object when people copy my work and attempt to pass it off as their own (sadly this does happen).

    Adam (Machanic) would no doubt want me to encourage you to share a link to SQLblog instead (traffic = advertising = pays the hosting bills) but I understand that is not always possible.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

Viewing 15 posts - 16 through 30 (of 34 total)

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