The "dms" files are for the COBOL modules. PSNTSRV is a C++ module. The SQL I'm trying to modify is show below. Only takes about 2 seconds but is perform everytime the Scheduler wakes up (does full table scans on these two tables). With a "hint" I could make it less then...
Is it possible to modify the "sql" that the Process Scheduler(PSPRCSRV)is using? I would like to add an "Oracle Hint" to a SELECT statement.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.