About the INNER LOOP JOIN syntax

I am analyzing a stored procedure on SQL Server 2000. The procedure was written on or before the year 1999. The procedure is joining tables using "INNER LOOP JOIN" syntax to join tables. I am assuming this is a carry over from older T-SQL, but I am not sure. I cannot find anything in BOL for this syntax. Can you shed any light on this?

    Requires Free Membership to View

Reference Inside SQL Server 2000 by Kalen Delaney. There is an abundance of information on query plans contained in it.

 

For More Information

This was first published in July 2003

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.