In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-09-23 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Tell us how the mysql optimizer handles our sql requests
This is not to say that there is an index on the relevant query column, and mysql can use it when querying. Although we think it is appropriate, the mysql optimizer does not necessarily think so.
Mysql does not necessarily associate tables according to the order in our sql statements, but automatically adjusts the association order according to the statistics of the index.
Id:
(id can only be two values: number, null. The number represents the order / number of select operations of sql to the database, the larger the id, the higher the priority; if it is null, it represents the result set produced by several statements union)
(in the figure above, there is a total of one select statement, so id displays 1. The first table corresponds to table b, the second table a, and the third table c. It can be seen that sql does not necessarily operate according to our association order (if the id value is the same, then the order from top to bottom)
(if the id value is different, the large one is the first and then the small one)
(the id is the same and different, the first is big, and the same is from top to bottom)
Select_type:
Table: displays the table name, or aliases if any
Partitions:
The partition key tries to select the query with less cross-partition
Type:
Performance is arranged from high to low:
Extra column:
File sorting using filesort may be on disk or in memory
Using temporary is similar to using filesort, using temporary table queries
Possible_keys:
Key:
Key_len:
Ref:
Rows:
Filtered:
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
The market share of Chrome browser on the desktop has exceeded 70%, and users are complaining about
The world's first 2nm mobile chip: Samsung Exynos 2600 is ready for mass production.According to a r
A US federal judge has ruled that Google can keep its Chrome browser, but it will be prohibited from
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
About us Contact us Product review car news thenatureplanet
More Form oMedia: AutoTimes. Bestcoffee. SL News. Jarebook. Coffee Hunters. Sundaily. Modezone. NNB. Coffee. Game News. FrontStreet. GGAMEN
© 2024 shulou.com SLNews company. All rights reserved.