APXINWKB PERFORMANCE PROBLEM

 this is a performance issue on that screen.

the query is slow on zx_zx_rec_nrec_dist table.

 i droped the following index

CREATE INDEX ZX.ZX_REC_NREC_DIST_N1 ON ZX.ZX_REC_NREC_DIST

 

(TRX_LINE_ID, REVERSE_FLAG)

LOGGING

TABLESPACE APPS_TS_TX_IDX5

PCTFREE    10

INITRANS   11

MAXTRANS   255

STORAGE    (

            INITIAL          16K

            NEXT             128K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            BUFFER_POOL      DEFAULT

           )

NOPARALLEL;

i created a new based index custom

CREATE INDEX ZX.ZX_REC_NREC_DIST_CM1 ON ZX.ZX_REC_NREC_DIST

(APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID,

NVL("SELF_ASSESSED_FLAG"