Abstract
Placing hints in SQL is a common and simple approach to improve performance. Hints influence Oracle’s optimizer to take a specific path to accomplish a given task, overriding the default path the optimizer may have chosen. Hints can also be viewed as a double-edged sword. If not implemented and maintained properly, they can hurt performance in the long run.
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
© 2011 Sam R. Alapati, Darl Kuhn, and Bill Padfield
About this chapter
Cite this chapter
Alapati, S.R., Kuhn, D., Padfield, B. (2011). Implementing Query Hints. In: Oracle Database 11g Performance Tuning Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3663-4_14
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3663-4_14
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3662-7
Online ISBN: 978-1-4302-3663-4
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books