You are a database administrator for a toy manufacturing company named NetFx.
The company stores all itsproduct-related data in a database named Netfx_data that resides on a SQL Server 2008 server named Server1 .
A table named Product_details exists in the database and contains the details of all the products manufacturedby the company.
The table contains a brief description of each product in the Prod_desc column that is definedas varchar(300) .
Users query the Product_details table by using SQL statements like the following:
SELECT Prod_name, Prod_id, Prod_desc
FROM Product_details
WHERE CONTAINS (Prod_desc, ‘ " Blue Toy" ‘);
You must ensure optimal performance of this query. What will you do to accomplish the objective?