






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, ...









What are Super Cognitive Foods? And Other Reads To Help You Work Better (Work Management Roundup)
Today is Friday the 13th, the subject of many an old school superstition and many a horror movie. If you’re stuck in the office today feeling terribly unproductive and a tad superstitious as to why, then we’re here...
