Missing indexes on engine2 database
List of DDL to create missing indexes on foreign keys.
Table | Missing index |
---|---|
network_cluster | CREATE INDEX idx_network_cluster_network_id ON network_cluster (network_id) |
network_cluster | CREATE INDEX idx_network_cluster_cluster_id ON network_cluster (cluster_id) |
network | CREATE INDEX idx_network_provider_network_provider_id ON network (provider_network_provider_id) |
network | CREATE INDEX idx_network_qos_id ON network (qos_id) |
event_notification_hist | CREATE INDEX idx_event_notification_hist_audit_log_id ON event_notification_hist (audit_log_id) |
lun_storage_server_connection_map | CREATE INDEX idx_lun_storage_server_connection_map_lun_id ON lun_storage_server_connection_map (lun_id) |
lun_storage_server_connection_map | CREATE INDEX idx_lun_storage_server_connection_map_storage_server_connection ON lun_storage_server_connection_map (storage_server_connection) |
job_subject_entity | CREATE INDEX idx_job_subject_entity_job_id ON job_subject_entity (job_id) |
gluster_server_hooks | CREATE INDEX idx_gluster_server_hooks_server_id ON gluster_server_hooks (server_id) |
gluster_server_hooks | CREATE INDEX idx_gluster_server_hooks_hook_id ON gluster_server_hooks (hook_id) |
gluster_volume_bricks | CREATE INDEX idx_gluster_volume_bricks_server_id ON gluster_volume_bricks (server_id) |
gluster_volume_bricks | CREATE INDEX idx_gluster_volume_bricks_network_id ON gluster_volume_bricks (network_id) |
gluster_cluster_services | CREATE INDEX idx_gluster_cluster_services_service_type ON gluster_cluster_services (service_type) |
gluster_services | CREATE INDEX idx_gluster_services_service_type ON gluster_services (service_type) |
repo_file_meta_data | CREATE INDEX idx_repo_file_meta_data_repo_domain_id ON repo_file_meta_data (repo_domain_id) |
storage_pool | CREATE INDEX idx_storage_pool_mac_pool_id ON storage_pool (mac_pool_id) |
tags_vds_map | CREATE INDEX idx_tags_vds_map_vds_id ON tags_vds_map (vds_id) |
tags_vds_map | CREATE INDEX idx_tags_vds_map_tag_id ON tags_vds_map (tag_id) |
tags_vm_pool_map | CREATE INDEX idx_tags_vm_pool_map_vm_pool_id ON tags_vm_pool_map (vm_pool_id) |
tags_vm_pool_map | CREATE INDEX idx_tags_vm_pool_map_tag_id ON tags_vm_pool_map (tag_id) |
snapshots | CREATE INDEX idx_snapshots_vm_id ON snapshots (vm_id) |
tags_user_map | CREATE INDEX idx_tags_user_map_tag_id ON tags_user_map (tag_id) |
tags_user_map | CREATE INDEX idx_tags_user_map_user_id ON tags_user_map (user_id) |
storage_pool_iso_map | CREATE INDEX idx_storage_pool_iso_map_storage_pool_id ON storage_pool_iso_map (storage_pool_id) |
storage_pool_iso_map | CREATE INDEX idx_storage_pool_iso_map_storage_id ON storage_pool_iso_map (storage_id) |
tags_user_group_map | CREATE INDEX idx_tags_user_group_map_tag_id ON tags_user_group_map (tag_id) |
tags_user_group_map | CREATE INDEX idx_tags_user_group_map_group_id ON tags_user_group_map (group_id) |
qrtz_triggers | CREATE INDEX idx_qrtz_triggers_job_name_sched_name_job_group ON qrtz_triggers (job_name.sched_name.job_group) |
vm_static | CREATE INDEX idx_vm_static_provider_id ON vm_static (provider_id) |
vm_static | CREATE INDEX idx_vm_static_vds_group_id ON vm_static (vds_group_id) |
vm_static | CREATE INDEX idx_vm_static_quota_id ON vm_static (quota_id) |
vm_static | CREATE INDEX idx_vm_static_large_icon_id ON vm_static (large_icon_id) |
vm_static | CREATE INDEX idx_vm_static_small_icon_id ON vm_static (small_icon_id) |
vm_static | CREATE INDEX idx_vm_static_vmt_guid ON vm_static (vmt_guid) |
vm_dynamic | CREATE INDEX idx_vm_dynamic_migrating_to_vds ON vm_dynamic (migrating_to_vds) |
vds_groups | CREATE INDEX idx_vds_groups_cluster_policy_id ON vds_groups (cluster_policy_id) |
vds_groups | CREATE INDEX idx_vds_groups_storage_pool_id ON vds_groups (storage_pool_id) |
vm_interface | CREATE INDEX idx_vm_interface_vm_guid ON vm_interface (vm_guid) |
vm_interface | CREATE INDEX idx_vm_interface_vmt_guid ON vm_interface (vmt_guid) |
vm_device | CREATE INDEX idx_vm_device_snapshot_id ON vm_device (snapshot_id) |
vds_static | CREATE INDEX idx_vds_static_vds_group_id ON vds_static (vds_group_id) |
vds_static | CREATE INDEX idx_vds_static_host_provider_id ON vds_static (host_provider_id) |
vds_spm_id_map | CREATE INDEX idx_vds_spm_id_map_vds_id ON vds_spm_id_map (vds_id) |
vds_spm_id_map | CREATE INDEX idx_vds_spm_id_map_storage_pool_id ON vds_spm_id_map (storage_pool_id) |
vm_pool_map | CREATE INDEX idx_vm_pool_map_vm_pool_id ON vm_pool_map (vm_pool_id) |
vm_interface_statistics | CREATE INDEX idx_vm_interface_statistics_vm_id ON vm_interface_statistics (vm_id) |
mac_pool_ranges | CREATE INDEX idx_mac_pool_ranges_mac_pool_id ON mac_pool_ranges (mac_pool_id) |
disk_lun_map | CREATE INDEX idx_disk_lun_map_disk_id ON disk_lun_map (disk_id) |
disk_lun_map | CREATE INDEX idx_disk_lun_map_lun_id ON disk_lun_map (lun_id) |
async_tasks_entities | CREATE INDEX idx_async_tasks_entities_async_task_id ON async_tasks_entities (async_task_id) |
gluster_server_services | CREATE INDEX idx_gluster_server_services_service_id ON gluster_server_services (service_id) |
cluster_policy_units | CREATE INDEX idx_cluster_policy_units_policy_unit_id ON cluster_policy_units (policy_unit_id) |
cluster_policy_units | CREATE INDEX idx_cluster_policy_units_cluster_policy_id ON cluster_policy_units (cluster_policy_id) |
roles_groups | CREATE INDEX idx_roles_groups_role_id ON roles_groups (role_id) |
tags_vm_map | CREATE INDEX idx_tags_vm_map_vm_id ON tags_vm_map (vm_id) |
tags_vm_map | CREATE INDEX idx_tags_vm_map_tag_id ON tags_vm_map (tag_id) |
image_storage_domain_map | CREATE INDEX idx_image_storage_domain_map_storage_domain_id ON image_storage_domain_map (storage_domain_id) |
image_storage_domain_map | CREATE INDEX idx_image_storage_domain_map_quota_id ON image_storage_domain_map (quota_id) |
vds_interface_statistics | CREATE INDEX idx_vds_interface_statistics_vds_id ON vds_interface_statistics (vds_id) |
vm_pools | CREATE INDEX idx_vm_pools_vds_group_id ON vm_pools (vds_group_id) |
event_subscriber | CREATE INDEX idx_event_subscriber_subscriber_id ON event_subscriber (subscriber_id) |
cpu_profiles | CREATE INDEX idx_cpu_profiles_qos_id ON cpu_profiles (qos_id) |
qrtz_simple_triggers | CREATE INDEX idx_qrtz_simple_triggers_trigger_name_trigger_group_sched_name ON qrtz_simple_triggers (trigger_name.trigger_group.sched_name) |
iscsi_bonds_storage_connections_map | CREATE INDEX idx_iscsi_bonds_storage_connections_map_iscsi_bond_id ON iscsi_bonds_storage_connections_map (iscsi_bond_id) |
iscsi_bonds_storage_connections_map | CREATE INDEX idx_iscsi_bonds_storage_connections_map_connection_id ON iscsi_bonds_storage_connections_map (connection_id) |
affinity_group_members | CREATE INDEX idx_affinity_group_members_vm_id ON affinity_group_members (vm_id) |
affinity_group_members | CREATE INDEX idx_affinity_group_members_affinity_group_id ON affinity_group_members (affinity_group_id) |
iscsi_bonds_networks_map | CREATE INDEX idx_iscsi_bonds_networks_map_iscsi_bond_id ON iscsi_bonds_networks_map (iscsi_bond_id) |
iscsi_bonds_networks_map | CREATE INDEX idx_iscsi_bonds_networks_map_network_id ON iscsi_bonds_networks_map (network_id) |
iscsi_bonds | CREATE INDEX idx_iscsi_bonds_storage_pool_id ON iscsi_bonds (storage_pool_id) |
gluster_volume_snapshots | CREATE INDEX idx_gluster_volume_snapshots_volume_id ON gluster_volume_snapshots (volume_id) |
gluster_volume_snapshot_config | CREATE INDEX idx_gluster_volume_snapshot_config_cluster_id ON gluster_volume_snapshot_config (cluster_id) |
gluster_volume_snapshot_config | CREATE INDEX idx_gluster_volume_snapshot_config_volume_id ON gluster_volume_snapshot_config (volume_id) |
storage_domains_ovf_info | CREATE INDEX idx_storage_domains_ovf_info_storage_domain_id ON storage_domains_ovf_info (storage_domain_id) |
gluster_georep_config | CREATE INDEX idx_gluster_georep_config_session_id ON gluster_georep_config (session_id) |
disk_profiles | CREATE INDEX idx_disk_profiles_qos_id ON disk_profiles (qos_id) |
gluster_georep_session | CREATE INDEX idx_gluster_georep_session_master_volume_id ON gluster_georep_session (master_volume_id) |
gluster_georep_session_details | CREATE INDEX idx_gluster_georep_session_details_session_id ON gluster_georep_session_details (session_id) |
gluster_georep_session_details | CREATE INDEX idx_gluster_georep_session_details_master_brick_id ON gluster_georep_session_details (master_brick_id) |
qrtz_blob_triggers | CREATE INDEX idx_qrtz_blob_triggers_trigger_group_sched_name_trigger_name ON qrtz_blob_triggers (trigger_group.sched_name.trigger_name) |
host_device | CREATE INDEX idx_host_device_host_id ON host_device (host_id) |
host_device | CREATE INDEX idx_host_device_host_id_physfn ON host_device (host_id.physfn) |
host_device | CREATE INDEX idx_host_device_vm_id ON host_device (vm_id) |
host_device | CREATE INDEX idx_host_device_host_id_parent_device_name ON host_device (host_id.parent_device_name) |
vfs_config_networks | CREATE INDEX idx_vfs_config_networks_network_id ON vfs_config_networks (network_id) |
command_assoc_entities | CREATE INDEX idx_command_assoc_entities_command_id ON command_assoc_entities (command_id) |
vm_icon_defaults | CREATE INDEX idx_vm_icon_defaults_small_icon_id ON vm_icon_defaults (small_icon_id) |
vm_icon_defaults | CREATE INDEX idx_vm_icon_defaults_large_icon_id ON vm_icon_defaults (large_icon_id) |
supported_cluster_features | CREATE INDEX idx_supported_cluster_features_cluster_id ON supported_cluster_features (cluster_id) |
supported_cluster_features | CREATE INDEX idx_supported_cluster_features_feature_id ON supported_cluster_features (feature_id) |
supported_host_features | CREATE INDEX idx_supported_host_features_host_id ON supported_host_features (host_id) |
network_attachments | CREATE INDEX idx_network_attachments_network_id ON network_attachments (network_id) |
vm_host_pinning_map | CREATE INDEX idx_vm_host_pinning_map_vds_id ON vm_host_pinning_map (vds_id) |
vm_host_pinning_map | CREATE INDEX idx_vm_host_pinning_map_vm_id ON vm_host_pinning_map (vm_id) |
user_password_history | CREATE INDEX idx_user_password_history_user_id ON aaa_jdbc.user_password_history (user_id) |
user_attributes | CREATE INDEX idx_user_attributes_user_id ON aaa_jdbc.user_attributes (user_id) |
failed_logins | CREATE INDEX idx_failed_logins_user_id ON aaa_jdbc.failed_logins (user_id) |
group_attributes | CREATE INDEX idx_group_attributes_group_id ON aaa_jdbc.group_attributes (group_id) |
user_groups | CREATE INDEX idx_user_groups_in_group_id ON aaa_jdbc.user_groups (in_group_id) |
user_groups | CREATE INDEX idx_user_groups_user_id ON aaa_jdbc.user_groups (user_id) |
group_groups | CREATE INDEX idx_group_groups_in_group_id ON aaa_jdbc.group_groups (in_group_id) |
group_groups | CREATE INDEX idx_group_groups_group_id ON aaa_jdbc.group_groups (group_id) |