Chapter 19. Monitoring and Tuning
SQL is the language used to create, retrieve, update, and delete (CRUD) data from databases. If your SQL statements are slow, the whole system suffers. Whether you're a developer or a DBA, effectively tuning SQL is a critical job requirement. When troubleshooting performance issues, you must know how to identify and tune resource-intensive queries.
A good developer must be familiar with query-tuning techniques. Ideally, developers will proactively evaluate queries for potential performance issues before they are deployed to production. In reality, bad SQL often makes it into production because it wasn't adequately tested, or the test environment does not accurately reflect the production environment (in terms of ...
Get Oracle SQL Recipes: A Problem-Solution Approach 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.
