Demantra Solutions - EBS (MOSC)

MOSC Banner

why does the Demantra Index Adviser suggest 2 worksheet indexes for each worksheet

edited Mar 31, 2017 5:00AM in Demantra Solutions - EBS (MOSC) 1 commentAnswered

I am trying to improve worksheet performance using the Index Adviser.  It is suggesting 2 worksheet indexes for each worksheet

here's an example

CREATE INDEX [WS_INDEX_2]_IDX ON MDP_MATRIX
(T_EP_EBS_CUST_CLASS_EP_ID, T_EP_L_ATT_2_EP_ID, T_EP_E1_ITEM_CAT_6_EP_ID, T_EP_P3_EP_ID, T_EP_SITE_EP_ID, FROM_DATE, UNTIL_DATE, LAST_UPDATE_DATE, SALES_DATA_LUD, T_EP_SITE_LUD, T_EP_EBS_CUST_CLASS_LUD, T_EP_P3_LUD)
TABLESPACE [TABLESPACE]
COMPUTE STATISTICS;

CREATE INDEX [WS_INDEX_2]_IDX ON MDP_MATRIX
(T_EP_EBS_CUST_CLASS_EP_ID, T_EP_L_ATT_2_EP_ID, T_EP_E1_ITEM_CAT_6_EP_ID, T_EP_P3_EP_ID, T_EP_SITE_EP_ID)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center