MySQL: Let's read the code!

We peek at MySQL server and try to comprehend what its query planner is trying to tell us.

Sorry the audio gets pretty choppy :(. There's nothing I can do in post to fix it.

Useful links:

Related videos:

Thanks for watching :)

[obudantkale]

So for views part, if you have tables like A, B and C
And you have multiple types of queries relating to all these tables, instead of making join every time, you can define a view which SQL optimises in its way
But yeah it's really deep engineering to understand how it does that