Comment 2 for bug 1666547

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)