Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

Table Access Order Expand / Collapse
Author
Message
Posted Tuesday, September 20, 2011 10:53 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
great question
Post #1178082
Posted Tuesday, September 20, 2011 10:57 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 21,385, Visits: 9,602
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 .
Post #1178084
Posted Tuesday, September 20, 2011 10:22 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 7:06 AM
Points: 1,216, Visits: 308
Nice question and learnt something!
Post #1178426
Posted Wednesday, September 21, 2011 3:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:49 PM
Points: 13,283, Visits: 10,156
Excellent question, thanks!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1178507
Posted Wednesday, September 21, 2011 4:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 8:38 AM
Points: 1,713, Visits: 6,249
SQL Kiwi (9/20/2011)
[quote]But who wants to be average?


I dream of being average, but have quite a way to go still to achieve it
Post #1178525
Posted Wednesday, September 21, 2011 6:55 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:34 AM
Points: 581, Visits: 728
Great question, Paul. It is always a good thing to know what is going on under the hood.

Thanks,

Matt

Post #1178599
Posted Thursday, September 22, 2011 2:52 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 26, 2014 5:34 AM
Points: 897, Visits: 1,486
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
Post #1179766
Posted Friday, September 23, 2011 12:06 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:56 PM
Points: 11,192, Visits: 11,096
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
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1179862
Posted Friday, September 23, 2011 7:52 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 26, 2014 5:34 AM
Points: 897, Visits: 1,486


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
Post #1180472
Posted Friday, September 23, 2011 10:47 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:56 PM
Points: 11,192, Visits: 11,096
codebyo (9/23/2011)


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
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1180484
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse