Bug 794057 (JBEPP-1125) - Verify index improvements on IDM and JCR tables
Summary: Verify index improvements on IDM and JCR tables
Keywords:
Status: ON_QA
Alias: JBEPP-1125
Product: JBoss Enterprise Portal Platform 5
Classification: JBoss
Component: Portal
Version: 5.1.0.GA
Hardware: Unspecified
OS: Unspecified
medium
high
Target Milestone: ---
: 5.2.x
Assignee: Martin Vecera
QA Contact:
URL: http://jira.jboss.org/jira/browse/JBE...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-08-25 09:30 UTC by Martin Weiler
Modified: 2018-11-28 19:22 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed:
Type: Task

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker JBEPP-1125 0 Major Closed Verify index improvements on IDM and JCR tables 2016-05-23 01:41:52 UTC

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
Note You need to log in before you can comment on or make changes to this bug.