Which type of index would you suggest to improve the query performance?

Previous Question
Next Question

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.
bitmap

B.
B-tree

C.
function based

D.
reverse key

Previous Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *