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、Convert the column to TEXT and add a fulltext index to the table
• B、Create multiple prefix indexes of differing lengths
• C、Convert their column to BINARY
• D、Redesign the table so that the most commonly searched for string patterns are in their own columns