You are designing a Microsoft SQL Server database named Orders.
You create a table according to the following schema:
You create a stored procedure to be used by an ASP.NET application that runs the following statement:
You need to ensure that the query runs as efficiently as possible.
What Transact-SQL statement should you run?
A.
B.
C.
D.