| table | index usage | rows | additional |
|---|---|---|---|
| category |
PRIMARY
|
2 / 16
13% of loaded rows used
|
full table scan
|
| film_category | no matching indexes |
200 / 2,000
10% of loaded rows used
|
full table scan
hash join |
| film |
PRIMARY
|
200 / 200
100% of loaded rows used
|
nested-loop join
index-only |
You should use the app on a larger display:
MySQL EXPLAINs include a lot of data that can not be simplified enough for a great experience on small mobile screens.