Abstract
There are several possible reasons why a poorly performing query does not work as expected. This ranges from the query plainly being wrong over a poor schema to lower-level causes such as a nonoptimal query plan or resource contention. This chapter will discuss some common cases and solutions.
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 Jesper Wisborg Krogh
About this chapter
Cite this chapter
Krogh, J.W. (2020). Change the Query Plan. In: MySQL 8 Query Performance Tuning. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5584-1_24
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5584-1_24
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5583-4
Online ISBN: 978-1-4842-5584-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books