Home Forums SQL Server 2012 SQL Server 2012 - T-SQL CROSS JOIN vs INNER JOIN performance issue. RE: CROSS JOIN vs INNER JOIN performance issue.

  • May 17, 2013 at 5:52 am

    #1616129

    T.Ashish (5/17/2013)

    Dear All,

    I have a query which was using CROSS JOIN (with relations) earlier and now we modified it with INNER JOIN.

    As per Prod server report, CROSS JOIN was performing faster but as per my theoretical knowledge, INNER JOIN should perform faster.

    I have attached Queries, IO Stats and Execution plan for your reference.

    Any guidance will be highly appreciated.

    It's much easier for folks to look at your problem if you post execution plans as .sqlplan attachments, and put queries directly into your post with the appropriate tags.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden