Established Member.. Iliev
Established Member..
156 views

PPM Support Tip: ITG_AUDIT_EVENTS table - indexes to improve performance

ITG_AUDIT_EVENTS table - indexes to improve performance:

 

If it gets found that full table scan is used in the execution plan of audit table (ITG_AUDIT_EVENTS) queries - The following Indexes can be created and tested for performance improvement if they do not already exist:       

 

create index ITG_AUDIT_EVENTS_N2 on ITG_AUDIT_EVENTS (ENTITY_ID, ENTITY_TYPE)
create index ITG_AUDIT_EVENTS_N3 on ITG_AUDIT_EVENTS (CONTAINER0_ID, CONTAINER0_TYPE)
create index ITG_AUDIT_EVENTS_N4 on ITG_AUDIT_EVENTS (CONTAINER1_ID, CONTAINER1_TYPE)
create index ITG_AUDIT_EVENTS_N5 on ITG_AUDIT_EVENTS (CONTAINER2_ID, CONTAINER2_TYPE)

create index ITG_AUDIT_EVENTS_N6 on ITG_AUDIT_EVENTS (USER_ID)

Labels (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.