Abstract
This chapter starts out discussing what an index is, some index concepts, and what drawbacks adding an index can have. Then the various index types and features supported by MySQL are covered. The next part of the chapter starts out discussing how InnoDB uses indexes particularly related to index-organized tables. Finally, it is discussed how to choose which indexes you should add to your tables and when to add them.
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
Notes
- 1.
Actually, there are cases where MySQL will auto-generate indexes specific to a single query. More about this later when discussing index features.
- 2.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 Jesper Wisborg Krogh
About this chapter
Cite this chapter
Krogh, J.W. (2020). Indexes. In: MySQL 8 Query Performance Tuning. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5584-1_14
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5584-1_14
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