$5\mathrm{.}9\mathrm{.}1$: LAB $-$ Query execution plans $($Sakila$)$

$0/10$

This lab illustrates how minor changes in a query may have a significant impact on the execution plan.

The lab consists of a MySQL Workbench exercise followed by a zyLab exercise. The MySQL Workbench exercise is not graded.

MySQL Workbench exercise

Refer to the film, actor, and film$\_$actor tables of the Sakila database. This exercise is based on the default Sakila installation. If you have altered these tables or their data, your results may be different.

Step $1.$ Open MySQL Workbench and enter the following statements:give program