Click here to monitor SSC
SQLServerCentral is supported by Redgate
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,448 reads
   Items 1 to 1 of 1