Bug 794057 (JBEPP-1125)

Summary: Verify index improvements on IDM and JCR tables
Product: [JBoss] JBoss Enterprise Portal Platform 5 Reporter: Martin Weiler <mweiler>
Component: PortalAssignee: Martin Vecera <mvecera>
Status: ON_QA --- QA Contact:
Severity: high Docs Contact:
Priority: medium    
Version: 5.1.0.GACC: epp-bugs, theute, tkobayas, trang.vu
Target Milestone: ---   
Target Release: 5.2.x   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/JBEPP-1125
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: Task
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Martin Weiler 2011-08-25 09:30:23 UTC 
Affects: Release Notes
Help Desk Ticket Reference: https://na7.salesforce.com/500A0000007reJZ
project_key: JBEPP

The following improvements regarding the indexes of the IDM and JCR tables have been identified:

-- IDM database
-- Modified
Drop Index  UQ_bid_io_1 on jbid_io
go
Create Unique Nonclustered index UQ_bid_io_1 
on jbid_io (IDENTITY_TYPE asc, NAME asc, REALM asc) 


-- JCR database
-- New
Create clustered index IX_jbid_io_attr_text_values_AttrID 
on jbid_io_attr_text_values(TEXT_ATTR_VALUE_ID asc)

-- New
CREATE NONCLUSTERED INDEX JCR_IDX_SITEM_PARENT
   ON JCR_SITEM (PARENT_ID asc, ID asc)


The impact of these index modifications should be evaluated during EPP 5.2 performance testing.
Comment 2 Jared MORGAN 2011-11-13 23:19:19 UTC 
Release Notes Docs Status: Added: Needs More Info
Comment 3 Jared MORGAN 2011-11-24 03:18:12 UTC 
Release Notes Text: Added: CAUSE:

CONSEQUENCE:

FIX:

RESULT:
Comment 5 Jared MORGAN 2011-11-28 00:12:46 UTC 
Release Notes Docs Status: Removed: Needs More Info Added: Not Yet Documented
Comment 6 Jared MORGAN 2011-11-28 02:33:05 UTC 
Affects: Added: Release Notes
Comment 8 Jared MORGAN 2011-12-01 01:44:35 UTC 
Release Notes Docs Status: Removed: Not Yet Documented Added: Not Required
Comment 10 Michal Vanco 2012-08-16 07:49:55 UTC 
Hi Martin,
can you provide more details about environment (specific DB) and more details how to verify indexes?
I can do some verification of common scenarios with indexes change.
Thanks