What should you do to improve the overall performance?

Your developers have created table to store some of their program’s data. After examining
the slow Query Log, you see that they are using the LIKE operator and SUBSTER ()
functions against a VARCHAR (10000) column quite often. An example of the start of one
row of data: ‘GREEN01020495888331993-12-10/2…’ What should you do to improve the
overall performance?

A.
Redesign the table so that the most commonly searched for string patterns are in their

own columns.

B.
Convert their column to BINARY.

C.
Convert the column to TEXT and add a fulltext index to the table.

D.
Create multiple prefix indexes of differing lengths.