Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Join Ordering Rss

   Items 1 to 1 of 1   
 

Join Reordering and Bushy Plans

Normally, the query Optimiser won't consider 'bushy' plans, where both operands to a join operator could be intermediate results from other joins. This means that it won't produce good query plans for some types of query. Hints, by themselves won't do it. More powerful magic is required.  Read more...
By Additional Articles 2013/04/03 | Source: SimpleTalk | Category: join ordering
Rating: (not yet rated)  Rate this |   Briefcase | 3,362 reads
   Items 1 to 1 of 1