Moti Asayag has uploaded a new change for review. Change subject: engine: Add index to network on storage_pool_id ......................................................................
engine: Add index to network on storage_pool_id The patch creates an index for network table for queries by storage-pool-id columns. Change-Id: I6b49d7fc1da196e192e0830a9197126bfd8431af Signed-off-by: Moti Asayag <masa...@redhat.com> --- A backend/manager/dbscripts/upgrade/03_02_0340_add_secondary_index_to_network.sql 1 file changed, 2 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/60/11260/1 diff --git a/backend/manager/dbscripts/upgrade/03_02_0340_add_secondary_index_to_network.sql b/backend/manager/dbscripts/upgrade/03_02_0340_add_secondary_index_to_network.sql new file mode 100644 index 0000000..6282e3b --- /dev/null +++ b/backend/manager/dbscripts/upgrade/03_02_0340_add_secondary_index_to_network.sql @@ -0,0 +1,2 @@ +-- Create partial index for fetching networks by storage pool id +CREATE INDEX IDX_network_storage_pool_id ON network(storage_pool_id); -- To view, visit http://gerrit.ovirt.org/11260 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I6b49d7fc1da196e192e0830a9197126bfd8431af Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Moti Asayag <masa...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
