Shulou(Shulou.com)05/31 Report--

This article mainly explains the "mysql query plan case analysis", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "mysql query plan case analysis"!

1. It is the plan content provided to the server by the optimizer based on the query statement. The way to query the plan is to add the EXPLAIN keyword before the query sentence.

SELECT city.name AS 'City', country.name AS' Country'FROM cityJOIN country ON (city.countrycode = country.code) WHERE country.code = 'GBR'LIMIT 5

2. Add EXPLAIN before the query sentence to see the query plan generated by the optimizer.

Skip everything except the end of the output and you can see the optimized query.

SELECT `world`.`city`.`Name`AS `City`, 'United Kingdom' AS `Country`FROM `world`.`city`JOIN `world`.`city`where (`world`.`city`.`CountryCode` =' GBR') City5. Thank you for reading. The above is the content of "mysql query Plan instance Analysis". After the study of this article, I believe you have a deeper understanding of the problem of mysql query plan instance analysis, and you still need to practice and verify the specific usage. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.