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»»

Inside the Optimizer: Constructing a Plan - Part 1 Expand / Collapse
Author
Message
Posted Wednesday, September 8, 2010 5:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 12:12 AM
Points: 13, Visits: 46
Thanks everyone. I'll look forward to the next articles. Hope you're alright down there (). I can see it has been a bit shaky in Christchurch some 350km away.
Post #982217
Posted Wednesday, September 8, 2010 6:43 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, November 20, 2014 7:53 PM
Points: 9,928, Visits: 11,194
hrc_public (9/8/2010)
Hope you're alright down there (). I can see it has been a bit shaky in Christchurch some 350km away.

Yes we're fine - ChCh is going to need a bit of work though. All very sad.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #982240
Posted Wednesday, September 8, 2010 6:45 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 11:41 PM
Points: 406, Visits: 778
It's amazing how you 'uncomplicate' things. That's what I like the most about your posts.

I saw Jeff's mention that rules should be enabled only on a test server. Does it mean that the improvements, that you make to queries this way, cannot be used in a real-world scenario?

Thanks for the links

- arjun
Post #982242
Posted Wednesday, September 8, 2010 6:46 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, November 20, 2014 7:53 PM
Points: 9,928, Visits: 11,194
Jeff Moden (9/8/2010)
I also recommend keeping track of the parts of the series... when you read part 4, you'll be itching to start from the beginning again.

I'll try to remember to include direct links to the previous parts in the opening comment of the discussion thread. That said, Steve is normally pretty good about adding links to previous parts to the article text too, so I'll check that first.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #982244
Posted Wednesday, September 8, 2010 6:55 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, November 20, 2014 7:53 PM
Points: 9,928, Visits: 11,194
Arjun Sivadasan (9/8/2010)
I saw Jeff mention that rules should be enabled only on a test server. Does it mean that the improvements, that you make to queries this way, cannot be used in a real-world scenario?

Nope, the optimizer normally produces a very good plan by using all of the rules.

What I am doing in this first part, is showing you what horrible plans can be produced if we prevent the optimizer from using all of its tricks.

The point is to show the process the optimizer goes through when searching for a great query plan.

Part 2 will be published in a few hours. In fact it's already an hour late in my time zone




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #982253
Posted Wednesday, September 8, 2010 7:03 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 11:41 PM
Points: 406, Visits: 778
Paul White NZ (9/8/2010)
What I am doing in this first part, is showing you what horrible plans can be produced if we prevent the optimizer from using all of its tricks.
The point is to show the process the optimizer goes through when searching for a great query plan.


Okay, I get it now. BTW 'mention' can also be used as a noun, so Jeff's mention is grammatically correct. :D

- arjun
Post #982263
Posted Wednesday, September 8, 2010 7:24 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 10, 2014 3:14 AM
Points: 334, Visits: 2,272
Me likes :)
Post #982277
Posted Thursday, September 9, 2010 4:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 10, 2010 2:07 AM
Points: 1, Visits: 11
+
Post #982947
Posted Thursday, September 9, 2010 7:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 26, 2011 1:32 PM
Points: 146, Visits: 327
Paul,

I knew you were in rarefied air when a Google search on 'NormalizeGbAgg SQL' returned 36 results and Bing returned 2 - both yours!

10 Star article

Doug
Post #983089
Posted Thursday, September 9, 2010 8:42 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:51 PM
Points: 17,948, Visits: 15,947
Nice article - good to see it published at SSC.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #983169
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse