152. 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
答案:B
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718678/,如需转载,请注明出处,否则将追究法律责任。