Abstract
You may not need to read this chapter! Database management systems (DBMS) are very efficient, and if you have a modest amount of data, most of your queries will probably be carried out in the blink of an eye. Complicating your life in an attempt to make your queries a little faster does not make a great deal of sense. However, if you have (or might have) vast amounts of data and speed is absolutely critical, you will need more skill and experience than you are likely to get from reading one chapter in a beginners’ book. Having said that, you are likely to have people tell you that it matters how you express your queries or that you should be indexing your tables, so it is handy to have some idea about what is going on behind the scenes and understand some of the terminology.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
SQL is based on relational calculus, which provides a description of the data to be retrieved. See Appendix 2 for more information.
- 2.
More formally the tuples in a relation have no order.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Clare Churcher
About this chapter
Cite this chapter
Churcher, C. (2016). Efficiency Considerations. In: Beginning SQL Queries. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1955-3_10
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1955-3_10
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1954-6
Online ISBN: 978-1-4842-1955-3
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)