Bug 1350313

Summary: Add index for better performance to vm disks usage tables
Product: Red Hat Enterprise Virtualization Manager Reporter: Shirly Radco <sradco>
Component: ovirt-engine-dwhAssignee: Shirly Radco <sradco>
Status: CLOSED DEFERRED QA Contact: Pavel Stehlik <pstehlik>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 3.6.8CC: bugs, gklein, lsurette, lsvaty, oourfali, rbalakri, Rhev-m-bugs, sradco, srevivo, ykaul
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1347996 Environment:
Last Closed: 2016-06-27 06:49:38 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Metrics RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1347996    
Bug Blocks:    

Description Shirly Radco 2016-06-27 06:26:29 UTC 
+++ This bug was initially created as a clone of Bug #1347996 +++

Description of problem:
Add index for better performance to vm disks usage tables

Version-Release number of selected component (if applicable):
4.0

How reproducible:


Steps to Reproduce:
1.Test query results against the tables in scale env before and after the change.

--- Additional comment from Oved Ourfali on 2016-06-22 02:44:48 EDT ---

Shirly - this isn't posted/merged in 4.0, so can't move to modified.
Alexander's patch is already merged on 4.0. Can you make sure to backport this ASAP?