Abstract
Whenever the query optimizer is unable to automatically generate an efficient execution plan, some manual tuning is required. For that purpose, Oracle provides several techniques. Table 7–1 summarizes them. The goal of this chapter is not only to describe these techniques in detail but also to explain what each technique can do for you and in which situations you can take advantage of them. To choose one of them, it is essential to ask yourself three basic questions:
-
• Is the SQL statement known and static?
-
• Should the measures to be taken have an impact on a single SQL statement or on all SQL statements executed by a single session (or even from the whole system)?
-
• It is possible to change the SQL statement?
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
Rights and permissions
Copyright information
© 2008 Christian Antognini
About this chapter
Cite this chapter
(2008). SQL Tuning Techniques. In: Troubleshooting Oracle Performance. Apress. https://doi.org/10.1007/978-1-4302-0498-5_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0498-5_7
Publisher Name: Apress
Print ISBN: 978-1-59059-917-4
Online ISBN: 978-1-4302-0498-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books