SQL Server Performance

Inner Joins

Discussion in 'ALL SQL SERVER QUESTIONS' started by MamtaSharma, Mar 9, 2012.

  1. MamtaSharma New Member

    Is this a possible performance issue if in join I place largest table first. Suppose I have tables A and B, table A has thousands of rows while table B has few records.

    Which would be a better query (performancewise) :

    A inner join B OR B inner join A

    pls give your 2 cents on this.

  2. FrankKalis Moderator

    Welcome to the forum!
    Theoretically there is no difference between both and in most cases the optimizer is smart enough to work it out when appropriate indexes are in place and statistics are up to date. Is this a theoretical question or do you face concrete issues?
  3. MamtaSharma New Member

    Thanks!. I was using this query in our company's webapplcation. I thought It can be a performance issue later on. I really appreciate your reply.

Share This Page