The payment and rental tables see heavy action — every rental transaction updates these tables, making them prime "hot spots." Queries like SELECT max(payment_date) FROM payment often trigger full table scans.
SELECT actor.first_name, actor.last_name, COUNT(*) FROM sakila.film_actor INNER JOIN sakila.actor USING(actor_id) GROUP BY film_actor.actor_id; sakila hot sences target