Re: PeopleSoft DBA's

Sorry it took so long to reply. I don't have a list with me, there at work. But off the top of my head, they include

PS_PERS_SRCH_US
PS_EMPLMNT_SRCH
PS_EMPL_COMP_SRCH
PS_DEPARTMENT_SRCH
PS_PAY_CHECK_VW_ZZ

We just dumped the create DDL to a file and edited the file and stuck in </*+ choose */>. We did not change the DDL within PeopleTools so it won't get flagged on an upgrade. There are about 1 or 2 more that I can't remember, and 1 or 2 customized which wouldn't pertain here.

Mitchell Loren wrote in message <376ECBDA.F2455F5C_at_home.com>...
>Would you mind getting more specific about how and with which views you
>changed ? Also, have you come across any on-line (or other) guides to PS
>performance tuning.
>
>Thanks
>
>Juan Carlos wrote:
>>
>> Technically, PeopleSoft wouldn't support it, although you could argue
that a
>> simple performance hint to an SQL statement doesn't change the selection
>> criterion. Since our on-line works best in cost, and batch in rule, we
>> considered adding hints to a bunch of DMS statements called by the COBOL,
>> but found that too daunting. The number of on-line search views we
changed
>> to include cost hints ended up being 8.
Received on Sat Jun 26 1999 - 08:14:22 CDT