Very Computer

thanks,
Winslow Chang

We are using Peopletools 7.07 on Oracle 8.1.7 (32bit).    Almost all
processes
will run faster using the rule based optimizer.   The users like ALL
ROWS better
than FIRST ROWS,  the batch jobs run much faster.   There are only a
few processes that run faster under Rule.   I don't think I have run
across any Cobol programs that run faster under Rule.  I analyze all
the Tables weekly and the most frequently updated ones nightly.

I would not make the change in your cobol program, make the change in
your init.ora file.  I am using Precise to to see how individual
programs work under
rule vs cost.  I think at one time Peoplesoft recommended using the
rule based optimizer, but most sites are using cost.

Quote:>in Informix a little under 30 minutes.   The Oracle database is
>running in RULE based mode as suggested by peoplesoft.

Quote:>in less than an hour on their box....I've tried setting the optimizer
>goal to CHOOSE on the instance level and that pretty much did the
>trick BUT

Quote:>Peoplesoft considers any type of modification to their cobol program a
>"custimization" and won't support the module thereafter...so I can't
>do that. :(

Quote:>changing any cobol code?   IF not, has anyone any tuning tips for
>this?

Set it to CHOOSE at instance level, make sure you ANALYZE all tables
and indexes when the COBOL batch is NOT running.  That should fix just
about most problems.  If you find a few blowouts and upon analyzing
the SQL involved you find that hash joins are involved and are blowing
out, just disable hash joins at instance level.  They have never
worked well for me with Peoplesoft.

HTH

Cheers
Nuno Souto