Decoding MySQL EXPLAIN Query Results for Better Performance (Part 2)
Too Long; Didn't ReadI used two tables student_details and address table. I have attached the table structure and respective index structure at the end of this blog. I provided the information for all the columns except **type** and **extra**. The type** column provides information about how the tables are joined. Different types of the ** type** are described below.