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

题目

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

相似考题

1.My opinions are similar to ___.A.youB.yourC.yoursD.your's

2.下列程序的运行结果是【 】。 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()}

3.若有以下定义： char s(10)="program"，t[]="test"； 则下列选项中对字符串操作错误的是( )。A．strcpy(s,t)；B．strcat(s,t)；C．cout＜＜strlen(s)；D．gets(s)；

4.What's ( )job? Are ( ) British?A. your, yourB. you, yourC. your, you

更多“Your developers have created table to store some of their program‘s data.After examining t ”相关问题

  • 第1题：

    下列各个选项中对字符数组赋字符串的语句中，错误的是( )。

    A．char s[10];s="program"；

    B．char s[]="program"；

    C．char s[10]="program"；

    D．char s[10]; strcpy(s,"program")；


    正确答案：A

  • 第2题：

    I saw the cargo surveyor ______ the cargo on deck just a minute ago．

    A.examine

    B.to examine

    C.being examined

    D.examining


    正确答案：D

  • 第3题：

    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．

    答案：B
    解析：
    考查纠错方法。教师在学生回答出现错误的时候，没有马上纠正，而是用反问的语气重复了一遍错误的句子，并把重音放在错误的单词上，这是教师间接纠错的方式之一。故选B。
    名师如何巧解题？查看视频解析>>

  • 第4题：

    执行下列命令后,最后一条命令输出的结果是______。STORE"?"TO A1STORE"S"TO A2 STORE 200 TO &

    执行下列命令后，最后一条命令输出的结果是______。 STORE"?"TO A1 STORE "S" TO A2 STORE 200 TO &A2 ?&A1．&A2

    A．200S

    B．200

    C．?200S

    D．?S


    正确答案：B

  • 第5题：

    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 correction
    B．Indirect correction
    C．Self-correction
    D．Peer correction

    答案：B
    解析：
    考查纠错方法。教师在学生回答出现错误的时候，没有马上纠正，而是用反问的语气重复了一遍错误的句子．并把重音放在错误的单词上，这是教师间接纠错的方式之一。故选B。

  • 第6题：

    What is the teacher doing in terms of error correction?
    T: Make a sentence with "have".t
    S: 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.

    答案：B
    解析：
    考查课堂纠错。教师在学生回答出现错误的时候，没有马上纠正，而是用反问的语气重复了一遍错误的句子．并把重音放在错误的单词上．这是教师间接纠错的方式之一。故选B。

相关内容