In the previous chapter, you learned to apply queries on your data stored in the MySQL database. You learned the different syntax of the select query, how to join tables, and how to apply aggregate functions on the table.
In this chapter, you will learn below topics on what is indexing and different types of indexes:
- MySQL indexing
- MySQL index types
- Indexing JSON data
Let's assume that we have a database table that has more then 50 lakh records of email addresses and you want to fetch one record out of this table. Now, if you write a query to fetch an email address, MySQL will have to check in each and every row for the values matching your queried email address. If MySQL takes one microsecond to scan one record, then it will take around five seconds to load just one record and, as the number of records increases in a table...
