SQL data execution plan

Question

Does

SELECT TOP 1000 * FROM TABLE

return the same data execution plan as

SELECT * FROM TABLE?

Please also let me know if this should be moved to ServerFault.

Thanks.

Answer 1

You can check for yourself. In SSMS, go to Query -> Include Actual Execution Plan

Then run your queries.

e.g. when I run:

SELECT TOP 10 * FROM sys.tables
SELECT * FROM sys.tables

They return different execution plans.