In the previous chapter, we learned about storage engines. Now we are aware what types of storage engines are available and which ones to use for our requirements. The previous chapter also covered the InnoDB storage engine in detail, along with other storage engine information. It also described how to define a custom storage engine for use, with a practical example. Now it's time to understand one more important functionality of MySQL 8 and that is, indexing. We will cover different types of indexes with their functionalities, which will encourage you to use indexes and provided you with guidance on how to use them. So, your journey into indexes has started! Let's go.
We will cover the following topics in this chapter:
- An overview on indexing
- Column-level indexing
- B-Tree indexes
- Hash indexes
- Index extensions
- Using an optimizer for indexes
- Invisible...
