Re: Help !! Hints and Explain Plan

Here's the entire query
SELECT /*+ COST */ /*+ INDEX(AIS.ACCOUNT_TYPE CODE) */ *
FROM

AIS.ACCOUNT_TYPE, AIS.DIVISION,
AIS.EXPENDITURE_CLASS, AIS.FUNDING_SOURCE, AIS.MAJOR_FUND_GROUP, 
AIS.PROJECT_NUM

AND AIS.TMP_EXP.ACCOUNT_TYPE=AIS.ACCOUNT_TYPE.CODE
AND AIS.TMP_EXP.EXPENDITURE_CLASS=AIS.EXPENDITURE_CLASS.CODE
AND AIS.TMP_EXP.UNIT_NUMBER=AIS.UNIT_NUMBER.CODE
AND AIS.TMP_EXP.MAJOR_FUND_GROUP=AIS.FUNDING_SOURCE.MAJOR_FUND_GROUP
AND AIS.TMP_EXP.FUNDING_SOURCE=AIS.FUNDING_SOURCE.CODE
AND AIS.TMP_EXP.MAJOR_FUND_GROUP=AIS.PROJECT_NUMBER.MAJOR_FUND_GROUP
AND AIS.TMP_EXP.PROJECT_NUMBER=AIS.PROJECT_NUMBER.CODE
AND AIS.TMP_EXP.DIVISION_NUMBER=AIS.DIVISION.CODE
AND ais.bud_ctr96.new_bud_ctr='AFLS'
AND AIS.BUD_CTR96.DEPT96=AIS.TMP_EXP.UNIT_NUMBER;