Decoding MySQL EXPLAIN Query Results for Better Performance (Part 2)by@mamit

Decoding MySQL EXPLAIN Query Results for Better Performance (Part 2)

tldt arrow
Read on Terminal Reader
Read this story w/o Javascript

Too Long; Didn't Read

I 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.
featured image - Decoding MySQL EXPLAIN Query Results for Better Performance (Part 2)
Amit Tiwary HackerNoon profile picture

@mamit

Amit Tiwary


Receive Stories from @mamit

react to story with heart

RELATED STORIES

L O A D I N G
. . . comments & more!
Hackernoon hq - po box 2206, edwards, colorado 81632, usa