Review BE modules that have a DB and:

• Determine if DROP INDEX instructions can be removed

• Determine if there are CREATE INDEX instructions for indexes maintained by RMB

Note: https://folio-org.atlassian.net/browse/CIRCSTORE-375#icft=CIRCSTORE-375 comments, specifically

RMB has optimized index re-creation since the Fameflower release, therefore the DROP INDEX snippet no longer works as intended and should be removed.

Please do not add "CREATE INDEX" for indexes that are maintained by RMB. If there really is a need to recreate an index remove it from RMB's rmb_internal_index table so that RMB recreates it: https://github.com/folio-org/raml-module-builder/blob/v35.0.3/domain-models-runtime/src/main/resources/templates/db_scripts/rmb_internal_index.ftl