-
Book Overview & Buying
-
Table Of Contents
Oracle SQL Developer 2.1
By :
As mentioned, tuning encompasses a full range of subjects, including tuning the database and tuning SQL statements. In SQL Developer, we only look at the latter, focusing on SQL and PL/SQL statements. When writing SQL, it is important to bear in mind that every query written and executed uses system resources. When tuning code, the main concern is to reduce the impact of the execution of the code on the system, effectively reducing the workload. Oracle prepares and compiles an execution plan for all of the DML statements executed. This execution plan shows the SQL optimizer's query execution path and is reused if a query is an exact match to a previously executed query. Oracle provides a number of utilities to read and review these execution plans.
In this first section, we'll look at the queries written and executed in the SQL Worksheet and how you can use the SQL Developer tools provided to examine the code written.
Change the font size
Change margin width
Change background colour