Abstract
In this part of the book, I have gone over many aspects of writing T-SQL code. I started with going over the use of set-based design in queries. When designing queries, it will also be important to design queries that use hardware effectively. One way that you can check the performance of your queries is using execution plans. Once you have an execution plan of a query you are wanting to improve, you can start focusing on how to optimize the query. There are some options available when it comes to optimizing T-SQL.
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
© 2020 Elizabeth Noble
About this chapter
Cite this chapter
Noble, E. (2020). Optimize T-SQL. In: Pro T-SQL 2019. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5590-2_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5590-2_8
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5589-6
Online ISBN: 978-1-4842-5590-2
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)