Bug 678279
Summary: | Perf: Add an index on rhq_resource (inventory_status) | ||
---|---|---|---|
Product: | [Other] RHQ Project | Reporter: | Heiko W. Rupp <hrupp> |
Component: | Database | Assignee: | Nobody <nobody> |
Status: | NEW --- | QA Contact: | |
Severity: | medium | Docs Contact: | |
Priority: | low | ||
Version: | 4.0.0 | CC: | jshaughn, rbuck |
Target Milestone: | --- | ||
Target Release: | --- | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | Type: | --- | |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: | |||
Bug Depends On: | |||
Bug Blocks: | 620933 |
Description
Heiko W. Rupp
2011-02-17 12:29:55 UTC
Given the low cardinality of the field would this index really be helpful or would the index just add overhead to insert/deletes on resources? Heiko, Are there particular queries you know are slow because of no index here? We need more justification for adding this. I don't recall. Original idea came from observations in OracleEM. |