Abstract
An execution plan describes the operations carried out by the SQL engine to execute a SQL statement. Every time you have to analyze a performance problem related to a SQL statement, or simply question the decisions taken by the query optimizer, you must know the execution plan. Without it, you’re like a blind man with his cane in the middle of the Sahara Desert, groping around trying to find his way. I can’t stress enough that the first thing to do while analyzing or questioning the performance of a SQL statement is to get its execution plan.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsNotes
- 1.
In other words, it’s a global temporary table created with the on commit preserve rows option.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Christian Antognini
About this chapter
Cite this chapter
Antognini, C. (2014). Execution Plans. In: Troubleshooting Oracle Performance. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-5759-2_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-5759-2_10
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-5758-5
Online ISBN: 978-1-4302-5759-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books