Could anypne pls answer this Q for me?

Regards,
Vipassana


The credit controller for your organization has complained that the report she runs to show customers with bad credit ratings takes too long to run. You look at the query that the report runs and determine that the report would run faster if there were an index on the CREDIT_RATING column of the CUSTOMERS table.
The CUSTOMERS table has about 5 million rows and around 100 new rows are added every month. Old records are not deleted from the table.
The CREDIT_RATING column is defined as a VARCHAR2(5) field. There are only 10 possible credit ratings and a customer's credit rating changes infrequently. Customers with bad credit ratings have a value in the CREDIT_RATINGS column of 'BAD' or 'F'.
Which type of index would be best for this column?
A. B-Tree
B. bitmap
C. reverse key
D. function-based