试题详情
- 单项选择题 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
- D
关注下方微信公众号，在线模考后查看
热门试题
- Examinethedescriptio
- When executing
- Your database&
- Evaluate the&e
- Which two̳
- Given： What is
- 使用（）命令，可以在屏幕上输出一行数据，
- 对于系统表的空间，Oracle建议的大小
- Given： What is
- Which WebLogic
- Your database&
- （）是用PL/SQL、Java和C编写的
- At 10：30
- You are u
- Which three
- Evaluate the&e
- ClicktheExhibitbutto
- Which componen
- Consider the&e
- RMAN provides more g