Using the WEBI audit tables? Got a data model question for

other Auditor
9

I’m looking for any suggested index’s for the Audit tables

Found this one:

CREATE INDEX OBJ_A_EVENT_LOG_N1 ON 
OBJ_A_EVENT_LOG(A_EVLOG_N_APPID) 
TABLESPACE WHATEVER_IDX PCTFREE 10 STORAGE(INITIAL 5242880 NEXT 524288 PCTINCREASE 0 ) 
; 

CREATE INDEX OBJ_A_EVENT_LOG_N2 ON 
OBJ_A_EVENT_LOG(A_EVLOG_N_TYPEID) 
TABLESPACE WHATEVER_IDX PCTFREE 10 STORAGE(INITIAL 5242880 NEXT 524288 PCTINCREASE 0 )

Any others?

Chris Pohl :us: (BOB member since 2002-06-18)