Hi all,

I have this script that is being executed:

UPDATE ps_vchr_acctg_line
SET posting_process = 'ACCR'
WHERE appl_jrnl_id = 'ACCRUAL';


And we created this index and analyzed it:

CREATE INDEX PS_VCHR_ACCTG_LINE_UPG ON
PS_VCHR_ACCTG_LINE(APPL_JRNL_ID)
TABLESPACE TMAP_VCHR_LNIDX PCTFREE 10 STORAGE(INITIAL 2097152 NEXT 4694016 PCTINCREASE 1 )
;


Why is the optimizer not picking up this index. The table has 10 million rows.

lenaf7@yahoo.com