Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Out of the two given queries, which will perform faster!!! RE: Out of the two given queries, which will perform faster!!!

  • May 2, 2013 at 7:07 am

    #1611876

    they are the same query, but with a some expressions to calculate the field values.

    test it yourself by looking at the actual execution plans when you run them.

    they will both be table scans (clustered index scan if there is a clustered index) because there is no WHERE statement,

    even worse, the TOP 1000 has no ORDER BY, so the results could vary on the very next pass if any data changed, or any reindexing occurred.

    TOP does not guarantee repeatable results without an ORDER BY.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!