-
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
Selena Flowers
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|