Redundant indexes on engine database
List of useless indexes because they are redundant.
Contained | Containing |
---|---|
CREATE INDEX idx_business_entity_snapshot_command_id ON business_entity_snapshot USING btree (command_id) | CREATE UNIQUE INDEX uq_command_id_entity_id ON business_entity_snapshot USING btree (command_id. entity_id. entity_type. snapshot_type) |
CREATE INDEX idx_gluster_cluster_services_cluster_id ON gluster_cluster_services USING btree (cluster_id) | CREATE UNIQUE INDEX pk_gluster_cluster_services ON gluster_cluster_services USING btree (cluster_id. service_type) |
CREATE INDEX idx_gluster_hooks_cluster_id ON gluster_hooks USING btree (cluster_id) | CREATE UNIQUE INDEX idx_gluster_hooks_unique ON gluster_hooks USING btree (cluster_id. gluster_command. stage. name) |
CREATE INDEX idx_gluster_server_services_server_id ON gluster_server_services USING btree (server_id) | CREATE UNIQUE INDEX unique_gluster_server_services_server_service ON gluster_server_services USING btree (server_id. service_id) |
CREATE INDEX idx_gluster_volume_access_protocols_volume_id ON gluster_volume_access_protocols USING btree (volume_id) | CREATE UNIQUE INDEX pk_gluster_volume_access_protocols ON gluster_volume_access_protocols USING btree (volume_id. access_protocol) |
CREATE INDEX idx_gluster_volume_bricks_volume_id ON gluster_volume_bricks USING btree (volume_id) | CREATE UNIQUE INDEX idx_gluster_volume_bricks_volume_server_brickdir ON gluster_volume_bricks USING btree (volume_id. server_id. brick_dir) |
CREATE INDEX idx_gluster_volume_options_volume_id ON gluster_volume_options USING btree (volume_id) | CREATE UNIQUE INDEX idx_gluster_volume_options_volume_id_option_key ON gluster_volume_options USING btree (volume_id. option_key) |
CREATE INDEX idx_gluster_volume_transport_types_volume_id ON gluster_volume_transport_types USING btree (volume_id) | CREATE UNIQUE INDEX pk_gluster_volume_transport_types ON gluster_volume_transport_types USING btree (volume_id. transport_type) |
CREATE INDEX idx_gluster_volumes_cluster_id ON gluster_volumes USING btree (cluster_id) | CREATE UNIQUE INDEX gluster_volumes_name_unique ON gluster_volumes USING btree (cluster_id. vol_name) |
CREATE INDEX idx_image_storage_domain_map_image_id ON image_storage_domain_map USING btree (image_id) | CREATE UNIQUE INDEX pk_image_storage_domain_map ON image_storage_domain_map USING btree (image_id. storage_domain_id) |
CREATE INDEX idx_permissions_ad_element_id ON permissions USING btree (ad_element_id) | CREATE UNIQUE INDEX idx_combined_ad_role_object ON permissions USING btree (ad_element_id. role_id. object_id) |
CREATE INDEX idx_vds_interface_vds_id ON vds_interface USING btree (vds_id) | CREATE UNIQUE INDEX vds_interface_vds_id_name_unique ON vds_interface USING btree (vds_id. name) |
CREATE UNIQUE INDEX vm_ovf_generations_pkey ON vm_ovf_generations USING btree (vm_guid) | CREATE INDEX idx_vm_ovf_generations_vm_guid ON vm_ovf_generations USING btree (vm_guid) |
CREATE UNIQUE INDEX qrtz_triggers_pkey ON qrtz_triggers USING btree (sched_name. trigger_name. trigger_group) | CREATE INDEX idx_qrtz_t_n_state ON qrtz_triggers USING btree (sched_name. trigger_name. trigger_group. trigger_state) |
CREATE INDEX idx_vfs_config_networks_vfs_config_id ON vfs_config_networks USING btree (vfs_config_id) | CREATE UNIQUE INDEX vfs_config_networks_pk ON vfs_config_networks USING btree (vfs_config_id. network_id) |
CREATE INDEX idx_vfs_config_labels_vfs_config_id ON vfs_config_labels USING btree (vfs_config_id) | CREATE UNIQUE INDEX vfs_config_labels_pk ON vfs_config_labels USING btree (vfs_config_id. label) |