CHAPTER 15 SQL Performance Coding Guidelines
In this chapter, we provide a summary of various common practices and guidelines that help us in writing scalable SQL that performs well in our custom modules. We concentrate on SQL in particular because in the majority of cases with performance issues, poorly written SQL is the main culprit. Experienced Oracle Applications DBAs will first look for evidence of nonoptimal custom SQL code when the system exhibits performance problems, and practical advice in this chapter will help you in identifying poor SQL performance before it is deployed to a production environment. E-Business Suite modules are fairly optimized out of the box and customizations could potentially have a disrupting effect, so part ...
Get Oracle E-Business Suite Development & Extensibility Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
