题目内容

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
Convert their column to BINARY
D. Redesign the table so that the most commonly searched for string patterns are in their own colum

查看答案

搜索结果不匹配？点我反馈

更多问题

A地市电力公司营销部在开展用电信息采集建设的过程中依照市的实际情况进行了采集工程的勘设、设计、概（预）算编制，并编制了市物资需求，形成采购计划上报省公司，接下来组织了施工工作，并认为其本职工作已经全部完成。本案中A电力公司营销部的工作是否全部完成？

杭州岳庙中“还我河山”匾文是岳飞的手迹。

A. 正确
B. 错误

在同义突变中，三联体密码发生改变而（）。

A. 核苷酸不变
B. 碱基序列改变
C. 氨基酸种类不变
D. 核酸种类不变

对于呼吸、心跳骤停的伤病人，应立即送往医院。

A. 正确
B. 错误