Prev: Assign permissions t user defined functions
Next: Join Syntax multiple on
From: Tom Cooper on 29 Mar 2010 20:20
The online version of the poster is at

http://www.solidq.com/insidetsql/books/insidetsql2008/Logical%20Query%20Processing%20Poster.pdf

Tom

"tshad" <t(a)dslextreme.com> wrote in message
news:eQNPUv5zKHA.6124(a)TK2MSFTNGP02.phx.gbl...
>
> "Plamen Ratchev" <Plamen(a)SQLStudio.com> wrote in message
> news:qbednTTjT_KRrSzWnZ2dnUVZ_o-hnZ2d(a)speakeasy.net...
>> Yes, the order for the joins matters when you have outer joins. In
>> general the steps you describe is the logical order to process the joins.
>> In practice the query engine may do it differently, but the final results
>> should be the same as if the logical processing order is followed.
>>
>
> Sounds good.
>
>> Itzik Ben-Gan has a very good poster of the logical processing available
>> for download here:
>> http://www.solidq.com/insidetsql/books/insidetsql2008/
>>
>
> Couldn't find the poster, but I think I will get the book, however.
>
> Thanks,
>
> Tom
>
>> --
>> Plamen Ratchev
>> http://www.SQLStudio.com
>
>

From: tshad on 29 Mar 2010 20:28

"Tom Cooper" <tomcooper(a)comcast.net> wrote in message
news:eRnsf75zKHA.6124(a)TK2MSFTNGP02.phx.gbl...
> The online version of the poster is at
>
> http://www.solidq.com/insidetsql/books/insidetsql2008/Logical%20Query%20Processing%20Poster.pdf

Got it

Thanks,

Tom
>
> Tom
>
> "tshad" <t(a)dslextreme.com> wrote in message
> news:eQNPUv5zKHA.6124(a)TK2MSFTNGP02.phx.gbl...
>>
>> "Plamen Ratchev" <Plamen(a)SQLStudio.com> wrote in message
>> news:qbednTTjT_KRrSzWnZ2dnUVZ_o-hnZ2d(a)speakeasy.net...
>>> Yes, the order for the joins matters when you have outer joins. In
>>> general the steps you describe is the logical order to process the
>>> joins. In practice the query engine may do it differently, but the final
>>> results should be the same as if the logical processing order is
>>> followed.
>>>
>>
>> Sounds good.
>>
>>> Itzik Ben-Gan has a very good poster of the logical processing available
>>> for download here:
>>> http://www.solidq.com/insidetsql/books/insidetsql2008/
>>>
>>
>> Couldn't find the poster, but I think I will get the book, however.
>>
>> Thanks,
>>
>> Tom
>>
>>> --
>>> Plamen Ratchev
>>> http://www.SQLStudio.com
>>
>>
>


First  |  Prev  | 
Pages: 1 2
Prev: Assign permissions t user defined functions
Next: Join Syntax multiple on