Index Recommendation by Internal DBA Team for Agile Product Lifecycle Management (PLM) System (Doc ID 2973848.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Goal

Internal DBA team recommended the creation of below indexes.   Need Oracle to check the below indexes and confirm whether or not to create these.


• create index AGILE_O.IDX$$_40E80001 on AGILE_O.AGILE_FLEX("ROW_ID","ATTID");

• create index AGILE_O.IDX$$_40E80002 on AGILE_O.PAGE_THREE("LIST32","LIST33");

• create index AGILE_O.IDX$$_40E80003 on AGILE_O.PROPERTYTABLE("SELECTION");

• create index AGILE_O.IDX$$_40E90001 on AGILE_O.ACTIVITY(UPPER("NAME"));
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.