mysql> explain select distinct film.film_id from sakila.film inner joinsakila.film_actor using(film_id);+----+-------------+------------+------------+-------+------------------------------------------------------------------+--------------------+---------+---------------------+------+----------+------------------------------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+------------+------------+-------+------------------------------------------------------------------+--------------------+---------+---------------------+------+----------+------------------------------+
| 1 | SIMPLE | film | NULL | index | PRIMARY,idx_title,idx_fk_language_id,idx_fk_original_language_id | idx_fk_language_id | 1 | NULL | 1000 | 100.00 | Using index; Using temporary |
| 1 | SIMPLE | film_actor | NULL | ref | idx_fk_film_id | idx_fk_film_id | 2 | sakila.film.film_id | 5 | 100.00 | Using index; Distinct |
+----+-------------+------------+------------+-------+------------------------------------------------------------------+--------------------+---------+---------------------+------+----------+------------------------------+
2 rows in set, 1 warning (0.00sec)
mysql> explain select film_id from sakila.film where exists (select * from sakila.film_actor where film.film_id =film_actor.film_id);+----+--------------------+------------+------------+-------+----------------+--------------------+---------+---------------------+------+----------+--------------------------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+--------------------+------------+------------+-------+----------------+--------------------+---------+---------------------+------+----------+--------------------------+
| 1 | PRIMARY | film | NULL | index | NULL | idx_fk_language_id | 1 | NULL | 1000 | 100.00 | Using where; Using index |
| 2 | DEPENDENT SUBQUERY | film_actor | NULL | ref | idx_fk_film_id | idx_fk_film_id | 2 | sakila.film.film_id | 5 | 100.00 | Using index |
+----+--------------------+------------+------------+-------+----------------+--------------------+---------+---------------------+------+----------+--------------------------+
2 rows in set, 2 warnings (0.00 sec)