What should you do?

Your company identifies a stored procedure that runs slowly.
You review the execution plan for the stored procedure, and you discover the properties of a Clustered Index Scan operator as shown in the exhibit. (Click the Exhibit button.)

The stored procedure contains the following code:

You need to improve the performance of the stored procedure.
What should you do?
A. Add a FORCESEEK query hint to the SELECT statement.
B. Add a NOLOCK query hint to the SELECT statement.
C. Convert the table to an In-Memory OLTP optimized table.
D. Change the FileName column from varchar(512) to nvarchar(512).
E. Change the @FileName parameter from nvarchar(512) to varchar(512)