The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）A、B-treeB、bitmapC、reverse keyD、function based
The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）
- A、B-tree
- B、bitmap
- C、reverse key
- D、function based
相关考题：
在为student_db数据库的St_Info表录入数据时，常常需要一遍又一遍地输入“男”到学生“性别”列，以下（）方法可以解决这个问题。A、创建一个DEFAULT约束（或默认值）B、创建一个CHECK约束C、创建一个UNIQUE约束（或唯一值）D、创建一个PRIMARYKEY约束（或主键）
单选题The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）ABtreeBbitmapCreverse keyDfunction based
单选题要查询st_info表中姓"王"且单名的学生情况，可用（）命令。ASELECT * FROM st_info WHERE st_name LIKE ´王%´BSELECT * FROM st_info WHERE st_name LIKE ´王_´CSELECT * FROM st_info WHERE st_name=´王%´DSELECT * FROM st_info WHERE st_name=´王__´
单选题在为student_db数据库的St_Info表录入数据时，常常需要一遍又一遍地输入“男”到学生“性别”列，以下（）方法可以解决这个问题。A创建一个DEFAULT约束（或默认值）B创建一个CHECK约束C创建一个UNIQUE约束（或唯一值）D创建一个PRIMARYKEY约束（或主键）