SQL Optimization Techniques in PeopleSoft
The previous two chapters discussed how to obtain the performance metrics that can indicate the most time-consuming processes or activities on your system. In the case of the Application Engine and COBOL processes, traces can identify the particular step in the process that is costing the most time. Although significant amounts of time can be spent executing code in the client or application server processes, you’ll often find that the most time-consuming step turns out to involve the execution of SQL.
KeywordsApplication Engine Execution Plan Trace File Bind Variable Component Processor
Unable to display preview. Download preview PDF.