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?
A.
WHERE FREETEXT(notes, ‘%call%’) AND
B.
INNER JOIN FREETEXTTABLE(dbo.table1, notes, ‘call’)
AS t2 ON dbo.table1.ID = t2.key WHERE
C.
WHERE CONTAINS(notes, ‘call*’) AND
D.
WHERE CONTAINS(notes,*%call%’> AND
Explanation: