You are here

used_key_parts: EXPLAIN FORMAT=JSON provides insight into which part of multiple-column key is used

MySQL Performance Blog - Fri, 18/12/2015 - 12:20am

In the previous post for this ongoing “EXPLAIN FORMAT=JSON is Cool!” series, we discussed covered indexes and how the [crayon-56735a98f016f887500716-i/]  array can help to choose them wisely. There is one more type of multiple-column indexes: composite indexes. Composite indexes ...

The post used_key_parts: EXPLAIN FORMAT=JSON provides insight into which part of multiple-column key is used appeared first on MySQL Performance Blog.