Oracle Magazine, May/June 2019
Database Developer and DBA ETL BY CONNOR McDONALD A Higher Level Perspective on SQL Tuning Part 2 Identifying and diagnosing poorly performing SQL In my previous article on SQL tuning I discussed the importance of stepping back from focusing on a purely technical approach to tuning SQL Before tuning SQL statements the practitioners charged with the task must first understand the business requirement of the application components that execute that SQL so that they can validate the correctness of the SQL statements to meet that requirement Even when the SQLs correctness is validated it is still important to have the right focus when tuning an application As I mentioned in the previous article no business has a Lets make sure SQL runs fast model they have core functions that drive revenue It just so happens that these core functions are often backed by IT applications that execute SQL statements Hence the processing cost of a SQL statement is not linked to business success unless that cost has an impact on the delivery of those core business functions and ORACLE MAGAZINE MAY JUNE 2019 106 ORACLE DATABASE
You must have JavaScript enabled to view digital editions.