You now have good knowledge of the different types of index structures supported by MySQL and now how to create an index in MySQL. You also learned different types of indexes available in MySQL 8 such as clustered index, covering index, descending index, and invisible index. We got a good understanding of fulltext indexing and how natural language fulltext indexes and fulltext indexes on Boolean mode works.
In the next chapter, we will cover some interesting things to boost MySQL performance such as how to set up Memcache, usage of Memcache, Memcache configuration, using Memcache APIs, how to analyze data stored in Memcache, and how to use Memcache APIs in MySQL 8.
