The two will produce the same execution plan – either a table scan
, index scan
, or index seek
, depending on if/how you have your table indexed.
You can see for yourself – Displaying Graphical Execution Plans (SQL Server Management Studio) – See the section called “Using the Execution Plan Options”.