Abstract
There are two key tools for tuning PolyBase queries from within SQL Server: statistics and execution plans. In this chapter, we will see how statistics on external tables can allow SQL Server’s query optimizer to make better decisions regarding predicate pushdown and join order. Then, we will dig into execution plans, which will provide us information critical for optimizing query performance.
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 Kevin Feasel
About this chapter
Cite this chapter
Feasel, K. (2020). Query Tuning with Statistics and Execution Plans. In: PolyBase Revealed. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5461-5_11
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5461-5_11
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5460-8
Online ISBN: 978-1-4842-5461-5
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)