SQL query execution timings

It seems to me that the SQL Server is reusing the execution plan created for the first query to execute second and third query.

If this is not a production server, at YOUR OWN RISK, you can execute the following statement between the queries:

Reference: https://msdn.microsoft.com/en-us/library/ms174283.aspx

And hopefully all three queries will take same amount of time.

Obvious solution would be to have a index containing the fields on which you are trying to fire "ORDER BY" clause. it should resolve the issue.  

 

 For deep analysis/learning : 

If you have any idea about Client Statistics & Execution Plan, then please turn it on and run the queries again, you would be able to see that difference between execution.

Try to look for any thing that does scanning of Table or Index (which is considered as not good design and it requires to have proper index for your table.)

Hi,

You may need to do indexing in your table.

Please check below link -

http://stackoverflow.com/questions/2139980/bad-performance-of-sql-query-due-to-order-by-clause

Hi Mayur,

To check ecution time in sql use this code:-

mark as answer if solve your issue..