Moti Asayag has uploaded a new change for review. Change subject: engine: Add index to vm_guest_agent_interfaces ......................................................................
engine: Add index to vm_guest_agent_interfaces Add a patch to improve data selection from vm_guest_agent_interfaces by the vm_id. Change-Id: I91b7c39df4e6820399c76be34b8522391d8b6ee2 Signed-off-by: Moti Asayag <[email protected]> --- A backend/manager/dbscripts/upgrade/03_02_0110_add_index_to_vm_guest_agent_interfaces.sql 1 file changed, 2 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/87/10287/1 diff --git a/backend/manager/dbscripts/upgrade/03_02_0110_add_index_to_vm_guest_agent_interfaces.sql b/backend/manager/dbscripts/upgrade/03_02_0110_add_index_to_vm_guest_agent_interfaces.sql new file mode 100644 index 0000000..7522232 --- /dev/null +++ b/backend/manager/dbscripts/upgrade/03_02_0110_add_index_to_vm_guest_agent_interfaces.sql @@ -0,0 +1,2 @@ +-- Create partial index for fetching guest agent nics for a VM +CREATE INDEX IDX_vm_guest_agent_interfaces_vm_id ON vm_guest_agent_interfaces(vm_id); -- To view, visit http://gerrit.ovirt.org/10287 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I91b7c39df4e6820399c76be34b8522391d8b6ee2 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Moti Asayag <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
