|
|
|
|
|
|
|
|
|
PeopleSoft
Scripts and Code
Learn and Share >
PeopleSoft
Scripts & Code >
Scripts & Code |
|
PSoftPros.com
is proud to offer the Scripts and Code bits to be a successful Pro!
These Scripts are
FREE, However, Please read the
disclaimer
before downloading them.
|
|
force
S
QR
Bits
Force your SQR to run using the Rule-Based
Optimizer
Some SQR
processes run more efficiently and perform better if they use the
RULE based optimizer. However, your Database might be set to
use the cost-based optimizer.
The following code bit can be
placed in an SQC and called from your SQR. This will force the
SQR transaction to use the RULE based optimizer.
!
--------------------
! - BEGIN CODE
BIT
! --------------------
begin-procedure
force-rule-based
BEGIN-SQL
ALTER SESSION SET OPTIMIZER_GOAL
= RULE
END-SQL
end-procedure
force-rule-based
!
--------------------
! - END CODE BIT
!
--------------------
|
|
|
Force your SQR to run using the Rule-Based Optimizer
|
|
|
|
|
| |
|
|
|
|
|
|
Visit our Partner Sites |
|
|
|
|
|
