Allon Mureinik has submitted this change and it was merged. Change subject: db: remove storage_domain_static_view ...................................................................... db: remove storage_domain_static_view storage_domain_static_view is a complex view that is barely utilized. Removing the view should cause queries that use it to perform better. Change-Id: Ibc14c3648f7b9ca3d2d45dded9fafce5aa852172 Related-To: https://bugzilla.redhat.com/1247144 Signed-off-by: Idan Shaby <ishaby@redhat.com> --- M packaging/dbscripts/create_views.sql M packaging/dbscripts/storages_san_sp.sql M packaging/dbscripts/storages_sp.sql 3 files changed, 20 insertions(+), 44 deletions(-) Approvals: Jenkins CI: Passed CI tests Allon Mureinik: Looks good to me, approved Idan Shaby: Verified -- To view, visit https://gerrit.ovirt.org/44407 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: Ibc14c3648f7b9ca3d2d45dded9fafce5aa852172 Gerrit-PatchSet: 3 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Idan Shaby <ishaby@redhat.com> Gerrit-Reviewer: Allon Mureinik <amureini@redhat.com> Gerrit-Reviewer: Daniel Erez <derez@redhat.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Idan Shaby <ishaby@redhat.com> Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Tal Nisan <tnisan@redhat.com> Gerrit-Reviewer: automation@ovirt.org