-
Book Overview & Buying
-
Table Of Contents
Oracle SQL Developer 2.1
By :
In the previous section, we looked at SQL statements and at how using the Explain Plan output can assist you when you are learning to write queries that perform better. It is good to try to write sound queries from the outset, but more often than not, what happens is that users come back to the developers complaining about performance. In this case, there is no sense in starting to wade through all of the code in the application, instead you need to determine which queries have the greatest impact on the system, such as the top running SQL statements. Once you have determined where the offending code is, you can review the execution plans for each of these and then work at reducing the impact these have on the system by improving the statements.
SQL Developer provides a number of packaged reports that you can use when tuning your queries. You can start by looking at Data Dictionary Reports | Table | Statistics. These are simple reports...
Change the font size
Change margin width
Change background colour