I have ran Oracle Expert to find out the index recommendations.
I was confused about the following indexes, so I need your help !!
I am using Oracle 8.0.5.
Here are the recommendations by Oracle expert:

CREATE INDEX PR.IX_AUTH_WORK
ON PR.MWEBAUTH
(AUTH_WORK_ID,
AUTH_RES_ID,
AUTH_SECONDARY_STATUS,
AUTH_STATUS,
AUTH_RESTRICTED,
AUTH_TIMECARD,
AUTH_REM_AMOUNT,
AUTH_AMOUNT,
AUTH_ID)
LOGGING
INITRANS 2
MAXTRANS 255
TABLESPACE PROD
PCTFREE 10
STORAGE (
INITIAL 500K
NEXT 500K
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 1024);

CREATE INDEX PR.MWEBAUTH_IDX_004
ON PR.MWEBAUTH
(AUTH_RES_ID,
AUTH_RESTRICTED,
AUTH_TIMECARD,
AUTH_WORK_ID,
AUTH_START_DATE,
AUTH_FIN_DATE,
AUTH_ID,
AUTH_SCHEDULE,
AUTH_REM_AMOUNT)
TABLESPACE PROD
PCTFREE 10
STORAGE (
INITIAL 500K
NEXT 500K
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 1024);

CREATE INDEX PR.MWEBAUTH_IDX_005
ON PR.MWEBAUTH
(AUTH_STATUS,
AUTH_RESTRICTED,
AUTH_RES_ID,
AUTH_START_DATE,
AUTH_FIN_DATE,
AUTH_ID,
AUTH_WORK_ID)
TABLESPACE PROD
PCTFREE 10
STORAGE (
INITIAL 500K
NEXT 500K
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 1024);

CREATE INDEX PR.MWEBAUTH_IDX_015
ON PR.MWEBAUTH
(AUTH_SECONDARY_STATUS,
AUTH_WORK_ID,
AUTH_RES_ID,
AUTH_START_DATE,
AUTH_FIN_DATE,
AUTH_ID)
TABLESPACE PROD
PCTFREE 10
STORAGE (
INITIAL 500K
NEXT 500K
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 1024);

Que1. Auth_ID is a Primary key on this table, then why do you have to include that to
a composite index.
Que2. Why is it recommending to do LOGGING on only one composite index IX_AUTH_WORK
and not all ?
Que3. AUTH_WORK_ID and AUTH_RES_ID are foreign keys, should these be 1st in the
composite index to make sure that they will be used always !
Que4. Will separate indexes make it better than composite indexes.