January 2019
Intermediate to advanced
286 pages
7h 41m
English
Now, let's create a COMPOUND index, as we have indicated in our suggestions table for the previous indexes:

Let's see the result after creating the index. Here is our new table structure after creating an index:

Here is the result of our TRADITIONAL execution plan:

Here is the result of our execution plan in JSON format:
In our MySQL report output, MySQL took into consideration the COMPOUND index; here is a good example ...
Read now
Unlock full access