Home Forums SQL Server 2012 SQL Server 2012 - T-SQL JOIN BIG and SMALL TABLEs RE: JOIN BIG and SMALL TABLEs

  • August 26, 2014 at 2:03 am

    #1740941

    tony28 (8/25/2014)

    I added second sql plan with query with condition before update statistics..

    is this so big different between before and after ?

    here looks almost ok

    Don't you mean AFTER you updated statistics? If it were BEFORE, then the plan would be the same as your first post in this thread.

    “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