a. When there is large amount of data. For faster search mechanism indexes are appropriate.

b. To improve performance they must be created on fields used in table joins.

c. They should be used when the queries are expected to retrieve small data sets

d. When the columns are expected to a nature of different values and not repeated

e. They may improve search performance but may slow updates.