Did a fresh installation with mysql to query the indexes:

mysql> SELECT DISTINCT TABLE_NAME, COLUMN_NAME, INDEX_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 'cinder';
+----------------------------+---------------------+----------------------------------------+
| TABLE_NAME                 | COLUMN_NAME         | INDEX_NAME                             |
+----------------------------+---------------------+----------------------------------------+
| attachment_specs           | id                  | PRIMARY                                |
| attachment_specs           | attachment_id       | attachment_id                          |
| backups                    | id                  | PRIMARY                                |
| cgsnapshots                | id                  | PRIMARY                                |
| cgsnapshots                | consistencygroup_id | consistencygroup_id                    |
| clusters                   | id                  | PRIMARY                                |
| clusters                   | name                | name                                   |
| clusters                   | binary              | name                                   |
| clusters                   | race_preventer      | name                                   |
| consistencygroups          | id                  | PRIMARY                                |
| driver_initiator_data      | id                  | PRIMARY                                |
| driver_initiator_data      | initiator           | initiator                              |
| driver_initiator_data      | namespace           | initiator                              |
| driver_initiator_data      | key                 | initiator                              |
| driver_initiator_data      | initiator           | ix_driver_initiator_data_initiator     |
| encryption                 | encryption_id       | PRIMARY                                |
| group_snapshots            | id                  | PRIMARY                                |
| group_snapshots            | group_id            | group_id                               |
| group_type_projects        | id                  | PRIMARY                                |
| group_type_projects        | group_type_id       | group_type_id                          |
| group_type_projects        | project_id          | group_type_id                          |
| group_type_projects        | deleted             | group_type_id                          |
| group_type_specs           | id                  | PRIMARY                                |
| group_type_specs           | group_type_id       | group_type_id                          |
| group_types                | id                  | PRIMARY                                |
| group_volume_type_mapping  | id                  | PRIMARY                                |
| group_volume_type_mapping  | volume_type_id      | volume_type_id                         |
| group_volume_type_mapping  | group_id            | group_id                               |
| groups                     | id                  | PRIMARY                                |
| image_volume_cache_entries | id                  | PRIMARY                                |
| image_volume_cache_entries | host                | ix_image_volume_cache_entries_host     |
| image_volume_cache_entries | image_id            | ix_image_volume_cache_entries_image_id |
| messages                   | id                  | PRIMARY                                |
| migrate_version            | repository_id       | PRIMARY                                |
| quality_of_service_specs   | id                  | PRIMARY                                |
| quality_of_service_specs   | specs_id            | specs_id                               |
| quota_classes              | id                  | PRIMARY                                |
| quota_classes              | class_name          | ix_quota_classes_class_name            |
| quota_usages               | id                  | PRIMARY                                |
| quota_usages               | project_id          | ix_quota_usages_project_id             |
| quotas                     | id                  | PRIMARY                                |
| reservations               | id                  | PRIMARY                                |
| reservations               | usage_id            | usage_id                               |
| reservations               | allocated_id        | allocated_id                           |
| reservations               | project_id          | ix_reservations_project_id             |
| reservations               | deleted             | reservations_deleted_expire_idx        |
| reservations               | expire              | reservations_deleted_expire_idx        |
| services                   | id                  | PRIMARY                                |
| snapshot_metadata          | id                  | PRIMARY                                |
| snapshot_metadata          | snapshot_id         | snapshot_id                            |
| snapshots                  | id                  | PRIMARY                                |
| snapshots                  | volume_id           | snapshots_volume_id_fkey               |
| snapshots                  | cgsnapshot_id       | cgsnapshot_id                          |
| snapshots                  | group_snapshot_id   | group_snapshot_id                      |
| transfers                  | id                  | PRIMARY                                |
| transfers                  | volume_id           | volume_id                              |
| volume_admin_metadata      | id                  | PRIMARY                                |
| volume_admin_metadata      | volume_id           | volume_id                              |
| volume_attachment          | id                  | PRIMARY                                |
| volume_attachment          | volume_id           | volume_id                              |
| volume_glance_metadata     | id                  | PRIMARY                                |
| volume_glance_metadata     | volume_id           | volume_id                              |
| volume_glance_metadata     | snapshot_id         | snapshot_id                            |
| volume_metadata            | id                  | PRIMARY                                |
| volume_metadata            | volume_id           | volume_id                              |
| volume_type_extra_specs    | id                  | PRIMARY                                |
| volume_type_extra_specs    | volume_type_id      | volume_type_extra_specs_ibfk_1         |
| volume_type_projects       | id                  | PRIMARY                                |
| volume_type_projects       | volume_type_id      | volume_type_id                         |
| volume_type_projects       | project_id          | volume_type_id                         |
| volume_type_projects       | deleted             | volume_type_id                         |
| volume_types               | id                  | PRIMARY                                |
| volume_types               | qos_specs_id        | qos_specs_id                           |
| volumes                    | id                  | PRIMARY                                |
| volumes                    | consistencygroup_id | consistencygroup_id                    |
| volumes                    | group_id            | group_id                               |
| workers                    | id                  | PRIMARY                                |
| workers                    | resource_type       | resource_type                          |
| workers                    | resource_id         | resource_type                          |
| workers                    | service_id          | workers_service_id_fkey                |
+----------------------------+---------------------+----------------------------------------+
80 rows in set (0.00 sec)