MySQL, Query, Optimization, Web Performance, Database.
results: 1, in the form of select * from, where is the primary key can pass kill [except like] (using the primary key to query); index is not allowed. 2, with the select field a from tab where field a “above operator” form test, the results can still use the index query. [Use coverage index] Other