You need to recommend changes to the ERP application to resolve the search issue. The solution must minimize the impact on other queries generated from the ERP application. What should you recommend changing?
A. the data type of the ProductName column
B. the collation of the Products table
C. the collation of the ProductName column
D. the index on the ProductName column