Home Forums Article Discussions Article Discussions by Author Discuss content posted by peter.skoglund SELECT TOP RE: SELECT TOP

  • February 17, 2012 at 5:59 am

    #1448437

    SQL Kiwi (2/17/2012)

    Hugo Kornelis (2/17/2012)

    Since this is undocumented, there is no way to guarantee this even if it is true today.

    It isn't true and there are many ways to disprove it. This is a conveniently simple example:

    Wow! Thanks.

    Can you explain what's going on? I played around a bit with the code. Adding an ORDER BY changes the results, of course - but the execution plan remains the same (or, if there are differences, they are hidden in a place where I haven't looked).

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/