Abstract
To fully understand how the SQL Tuning Advisor tool works, we need to lay some groundwork and explain a few terms. Firstly, the Oracle query optimizer operates in two different modes: normal and tuning. When a SQL statement executes, the optimizer operates in normal mode and quickly identifies a reasonable execution plan. In this mode, the optimizer spends only a fraction of a second to determine the optimal plan.
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
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Darl Kuhn, Sam R. Alapati and Bill Padfield
About this chapter
Cite this chapter
Kuhn, D., Alapati, S.R., Padfield, B. (2016). SQL Tuning Advisor. In: Expert Oracle Indexing and Access Paths. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1984-3_9
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1984-3_9
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1983-6
Online ISBN: 978-1-4842-1984-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books