Post reply

Joins.... Joins.... Joins....

  • August 30, 2004 at 11:52 pm

    #163123

    Hi,

    I need very deep insights of "Join" computation by SQL Server. How do SQL Server computes joins?? What are the performance factors considered by sql server when computing joins??

    Also, is it preferred way to use combinations of different joins in a single query ?? (What are the impacts)

    Can anyone post a link where i find this information.

    Thanks in advance,

    Hatim Ali.

  • August 31, 2004 at 6:06 am

    #521194

    The query optimizer uses one of the three join methods (nested loops, merge, hash), based on the estimated number of records that will be selected and other informations from the statistics for the indexes on the table. See:

    http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_8pv7.asp

    Razvan

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply