Opinionated Software

… we have opinions about everything!

Archive for the ‘CRM’ Category

RC_BACKLOG_VW in PeopleSoft CRM 9.1 —

Seriously? Who thought it would be a good idea to create a view to return the DISTINCT list of BUSINESS_UNIT from RC_CASE? Talk about an O (n) performance disaster. What’s wrong with a SELECT BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_RC WHERE EXISTS (… case sub-query….). Oh look … Two index seeks … shocker! It scales too …. wow […]