Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Query Performance - MIN vs Top 1 RE: Query Performance - MIN vs Top 1

  • October 18, 2016 at 10:19 am

    #1907204

    Phil Parkin (10/18/2016)

    ChrisM@Work (10/18/2016)

    mitzyturbo (10/18/2016)

    Sorry Chris, forgot to attach the indexes

    Happy enough to go with the TOP 1 in a CROSS APPLY

    Thanks anyway

    Here's the ROW_NUMBER version. I think the index I posted earlier would be good for any of these queries.

    Where?

    Thanks Phil, got interrupted twice whilst posting that!

    “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