Abstract
A database schema may include a number of performance-enhancement features such as indexes, statistics, and stored procedures. But none of these features guarantees good performance if your queries are written badly in the first place. The SQL queries may not be able to use the available indexes effectively. The structure of the SQL queries may add avoidable overhead to the query cost. Queries may be attempting to deal with data in a row-by-row fashion (or to quote Jeff Moden, Row By Agonizing Row, which is abbreviated to RBAR and pronounced “reebar”) instead of in logical sets. To improve the performance of a database application, it is important to understand the cost associated with varying ways of writing a query.
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 subscriptionsPreview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Grant Fritchey
About this chapter
Cite this chapter
Fritchey, G. (2012). Query Design Analysis. In: SQL Server 2012 Query Performance Tuning. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4204-8_11
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4204-8_11
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4203-1
Online ISBN: 978-1-4302-4204-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books