Abstract
When a SQL statement references several tables, the query optimizer has to determine, in addition to the access path for each table, which order the tables are joined in and which join methods are used. The goal of the query optimizer is to minimize the amount of processing by filtering out unneeded data as soon as possible.
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.
Rights and permissions
Copyright information
© 2008 Christian Antognini
About this chapter
Cite this chapter
(2008). Optimizing Joins. In: Troubleshooting Oracle Performance. Apress. https://doi.org/10.1007/978-1-4302-0498-5_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0498-5_10
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