Answer B is correct. You must create a full-text index on the columns you would like to utilize. There is already going to be a catalog in place that can be used because similar functionality exists elsewhere in the database. There must also be a unique column identified in the table. No other forms of indexing will help in this scenario. For more information, see the following sources:
|