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 tableB.Create multiple prefix indexes of differing lengthsC.Convert their column to BINARYD.Redesign the table so that the most commonly searched for string patterns are in their own columns
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
相关考题：
下列程序的运行结果是【 】。 include class SomeClass { public: SomeClass(int va 下列程序的运行结果是【 】。include ＜iostream. h＞class SomeClass{public:SomeClass(int value) { some_value=value;};void show_data(void) { cout＜＜data＜＜"＜＜~some_value＜＜endl; };static void set_data(int value) {data=value; }private:static int data;int some_value};int SomeClass::datavoid main(void){SomeClass my_class(1001),your_class(2002);your_class. set_data(4004);my_elass. show_data()}
若有以下定义： char s(10)="program"，t[]="test"； 则下列选项中对字符串操作错误的是( )。A．strcpy(s,t)；B．strcat(s,t)；C．cout＜＜strlen(s)；D．gets(s)；
下列各个选项中对字符数组赋字符串的语句中，错误的是( )。A．char s[10];s="program"；B．char s[]="program"；C．char s[10]="program"；D．char s[10]; strcpy(s,"program")；
执行下列命令后,最后一条命令输出的结果是______。STORE"?"TO A1STORE"S"TO A2 STORE 200 TO A2 ?A1．A2A．200SB．200C．?200SD．?S
I saw the cargo surveyor ______ the cargo on deck just a minute ago．A.examineB.to examineC.being examinedD.examining
What is the teacher doing in terms on error correction?" Make a sentence with "have"!S: He have a car.T: He HA VE a car?S: He HAS a car." Very good. He HA S a car.A．Direct correctionB．Indirect correctionC．Self-correctionD．Peer correction
What is the teacher doing in terms of error correction?T:Make a sentence with"have"!S:He have a ear．T:He HAVE a car?S:He HAS a car．T:Very good．He HAS a car．A.Direct correction．B.Indirect correction．C.Self-correction．D.Peer correction．
What is the teacher doing in terms of error correction?T: Make a sentence with "have".tS: He have a car.T: He HA VE a car?S: He HA S a car.T: Very good. He HAS a car.A．Direct correction.B．Indirect correction.C．Self-correction.D．Peer correction.