how about Index stats? are you using cascade=> 'TRUE' option while gathering stats?I did build index in ID_EVEN and JOB_STATUS seperately and I also update stat using DBMS_STATS.GATHER_TABLE_STATS, but for some reason the index never been used unless I force the hint on the index.
Thanks,




Reply With Quote