Please find a list of the indexes, if you need any more information then please let me know.

TABLE_NAME INDEX_NAME COLUMNS

FDR_REC_STAGES REC_STAGE_I_ORDER (STAGE_ORDER)

FDR_REC_STAGES REC_STAGE_PK (REC_STAGE)

FDR_REC_HISTS REC_HIST_PK (ACC_ID, DEBT_SEQUENCE, REC_DATE)

FDR_REC_HISTS REC_I_STAGE (REC_STAGE)

FDR_SUSP_HISTS FDR_SUSP_HISTS (ADD_ID, DEBT_SEQUENCE)

Table FDR_REC_HISTS has 1000000 rows.
Table FDR_REC_STAGES has 29.
Table FDR_SUSP_HISTS has 4500 rows.


description of FDR_REC_STAGES :-
FDR_REC_STAGES (
REC_STAGE CHAR (3) NOT NULL,
DESCRIPTION VARCHAR2 (60) NOT NULL,
COMMENTS VARCHAR2 (40) NOT NULL,
PERCENT_COST NUMBER (4,2) NOT NULL,
STAGE_ORDER NUMBER (2) NOT NULL,
DEMINIMIS NUMBER (5,2),
INSTALMENT VARCHAR2 (1) DEFAULT 'N',
FN_IND VARCHAR2 (1),
REM_IND VARCHAR2 (1),
BAILIFF VARCHAR2 (1),
DSS_IND VARCHAR2 (1),
SUM_IND VARCHAR2 (1),
CSUM_IND VARCHAR2 (1),
LO_IND VARCHAR2 (1)

description of FDR_REC_HISTS :-

FDR_REC_HISTS (
ACC_ID VARCHAR2 (12) NOT NULL,
DEBT_SEQUENCE NUMBER (2) NOT NULL,
REC_DATE DATE NOT NULL,
CANCELDATE DATE,
CANCEL_ID CHAR (3),
COSTS NUMBER (10,2) NOT NULL,
REC_STAGE CHAR (3) NOT NULL,
REC_BY VARCHAR2 (8) NOT NULL,
COMMENTS VARCHAR2 (240),
DEBTAGEN NUMBER,
SUMMONS_ID NUMBER,
BALANCE NUMBER (10,2),
SHERDATE DATE,
S_O_CANCELLED VARCHAR2 (1),
RBT_ID VARCHAR2 (9)

description of FDR_SUSP_HISTS :-

FDR_SUSP_HISTS (
SUSP_DATE DATE NOT NULL,
EXPIRYDATE DATE,
ACC_ID VARCHAR2 (12) NOT NULL,
DEBT_SEQUENCE NUMBER (2) NOT NULL,
SUSP_TYPE CHAR (3) NOT NULL,
COMMENTS VARCHAR2 (240),
EXP_BY VARCHAR2 (8)