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

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?

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



Leave a Reply 0

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