bobbydurrettdba.com bobbydurrettdba.com

Update hinted for wrong index

I worked with our support team to improve the performance of a PeopleSoft Financials update statement yesterday. The update statement had an index hint already in it but the index was not the best one of the available indexes. Here is the original update statement: UPDATE /*+ INDEX(B PSCPYMNT_VCHR_XREF) */ PS_PYMNT_VCHR_XREF B SET BANK_SETID = :1, BANK_CD = :2, BANK_ACCT_KEY = :3, PYMNT_METHOD = :4, BANK_ACCT_SEQ_NBR = :5, ...