Abstract
Structured Query Language is like any other programming language in that it can be coded well, coded poorly, and everywhere in between. Learning to create efficient SQL statements has been discussed in countless books. This chapter zeroes in on basic SQL coding fundamentals, and addresses some techniques to improve performance of your SQL statements. In addition, some emphasis is given to ramifications of poorly written SQL, along with a few common pitfalls to avoid in your SQL statements within your application.
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). Creating Efficient SQL. In: Oracle Database 11g Performance Tuning Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3663-4_8
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3663-4_8
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