Oracle Magazine, March/April 2019
Database Developer and DBA ETL BY CONNOR McDONALD A Higher Level Perspective on SQL Tuning The commonly missed first steps of tuning a SQL statement Fire up your favorite search engine enter SQL tuning as the search term and you are likely to detect a common theme in the results They typically relate to modification of the database structure such as adding or removing indexes modification of the execution environment such as gathering or modifying optimizer statistics or more substantial modifications such as rewriting the SQL or changing the physical design of the database What is often missing in those same search engine results is a warning that any such modifications carry an inherent risk to the entire database environment in which the SQL statement is running The larger the modification the higher the risk As Oracle Database has evolved the number of tuning tools has grown and the level of sophistication of each of these tools has also increased giving developers and DBAs a plethora of options to explore One consequence is that it is easy to dive ORACLE MAGAZINE MARCH APRIL 2019 99 ORACLE DATABASE SQL
You must have JavaScript enabled to view digital editions.