X hits on this document

111 views

0 shares

0 downloads

0 comments

8 / 48

Big PeopleSoft Deployment (cont)

As with all bigger ISV packages the following issues can be observed in the query execution:

Dependent on customer’s data or application configuration queries might pick wrong plans at an individual customer

PSFT like many other ISV packages don’t allow index hints in their application coding

Query re-writes necessary sometimes at individual customer sites

Usage of plan guides proofed helpful, however sometimes painful - Biggest problem in how to get the correct plan to be saved away

‘OPTIMIZE FOR’ so far unusable due to steady changing data values

DBA-416M• ISV configurations & implementations – Lessons Learned

Document info
Document views111
Page views111
Page last viewedThu Dec 08 10:05:31 UTC 2016
Pages48
Paragraphs862
Words4327

Comments