<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Paul White
»
Inside the Optimizer: Constructing a Plan -...
16 posts, Page 1 of 2
1
2
»»
Inside the Optimizer: Constructing a Plan - Part 2
Rate Topic
Display Mode
Topic Options
Author
Message
Paul White
Paul White
Posted Wednesday, September 08, 2010 8:11 PM
SSChampion
Group: General Forum Members
Last Login: Yesterday @ 7:18 PM
Points: 10,989,
Visits: 10,532
Comments posted to this topic are about the item
Inside the Optimizer: Constructing a Plan - Part 2
Link to
Part 1
Link to
Part 3
Link to
Part 4
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #982753
Hugo Kornelis
Hugo Kornelis
Posted Thursday, September 09, 2010 12:47 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 2:24 AM
Points: 5,235,
Visits: 7,040
My sole critisicm of this article is that it's much too short.
I can't wait to read the parts three and four!
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
Post #982847
skyline6969
skyline6969
Posted Thursday, September 09, 2010 4:16 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, January 09, 2013 9:57 AM
Points: 4,
Visits: 79
Good article Paul, look forward to reading more on it!
I also would like to see more articles like this as I had studied general database engine low-level workings and theories (17 years ago I wrote a thesis on using compressed caches in database engines, never thought it would take this long to see even basic compression used - SQL 2008 being Microsoft's first real go at this lol).
It is great to see how SQL Server applies them, as outside open source code and Microsoft white papers it is rarely discussed now
.
Post #982945
bpportman 52825
bpportman 52825
Posted Thursday, September 09, 2010 6:20 AM
Grasshopper
Group: General Forum Members
Last Login: Yesterday @ 7:01 AM
Points: 22,
Visits: 236
Good article, but there is not enough information.
How are these done?
"The first one is achieved by a rule called JNtoIdxLookup. The second requirement is a correlated loops join - also known as an Apply. The rule needed to transform our query to that form is AppIdxToApp."
"We can remove this Compute Scalar, and the need to compute COUNT(*), by normalising the GROUP BY using a rule called 'NormalizeGbAgg'."
Post #983029
aeyates
aeyates
Posted Thursday, September 09, 2010 6:46 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, July 24, 2012 7:41 AM
Points: 10,
Visits: 21
Do you have before/after timings?
Was the query statement unchanged?
Did you add an index?
It is not clear how the query was improved.
Post #983044
Rick-153145
Rick-153145
Posted Thursday, September 09, 2010 7:35 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, April 18, 2013 1:24 AM
Points: 178,
Visits: 261
Great series, looking forward to the next two instalments.
I feel I must point out this great typo though, made me chuckle:
"1. Convert the naive nested loops join to an index nested loops join "
Post #983076
Paul White
Paul White
Posted Thursday, September 09, 2010 8:05 AM
SSChampion
Group: General Forum Members
Last Login: Yesterday @ 7:18 PM
Points: 10,989,
Visits: 10,532
bpportman 52825 (9/9/2010)
Good article, but there is not enough information. How are these done?
That would leave me nothing to say in Parts 3 & 4!
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #983102
Paul White
Paul White
Posted Thursday, September 09, 2010 8:15 AM
SSChampion
Group: General Forum Members
Last Login: Yesterday @ 7:18 PM
Points: 10,989,
Visits: 10,532
aeyates (9/9/2010)
Do you have before/after timings?
No.
Was the query statement unchanged?
Yes.
Did you add an index?
No.
It is not clear how the query was improved.
The series is about how the query optimizer works internally. I am showing some of the plan alternatives it considers on the way to finding the final plan. Part 3 and Part 4 of this series will reveal the magic.
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #983111
Paul White
Paul White
Posted Thursday, September 09, 2010 8:24 AM
SSChampion
Group: General Forum Members
Last Login: Yesterday @ 7:18 PM
Points: 10,989,
Visits: 10,532
Rick-153145 (9/9/2010)
I feel I must point out this great typo though, made me chuckle:
"1. Convert the naive nested loops join to an index nested loops join "
I still can't see a typo there, Rick.
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #983128
Paul White
Paul White
Posted Thursday, September 09, 2010 8:34 AM
SSChampion
Group: General Forum Members
Last Login: Yesterday @ 7:18 PM
Points: 10,989,
Visits: 10,532
Hugo Kornelis (9/9/2010)
My sole critisicm of this article is that it's much too short.
I can't wait to read the parts three and four!
Thank you, Hugo.
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #983152
« Prev Topic
|
Next Topic »
16 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
