Câu 60: 70-464: Developing Microsoft SQL Server 2012/2014 Databases

You have a database named Database1. You execute the following code: You have the following query. (Line numbers are included for reference only.) Users report that the query takes a long time to complete. You create a full-text index for the Notes column. You need to recommend changes to the query to reduce the amount of time it takes for the query to complete. Which code segment should you use to replace line 03?

1. A. WHERE FREETEXT(notes, '%call%') AND — đáp án hiện tại
2. B. INNER JOIN FREETEXTTABLE(dbo.table1, notes, 'call') AS t2 ON dbo.table1.ID = t2.key WHERE
3. C. WHERE CONTAINS(notes, 'call*') AND
4. D. WHERE CONTAINS(notes,*%call%'> AND