In case you have your own slow SQL query, you can optimize it automatically here.
For the query above, the following recommendations will be helpful as part of the SQL tuning process.
You'll find 3 sections below:
ALTER TABLE `movie_info` ADD INDEX `movie_info_idx_info_id_info_movie_id` (`info_type_id`,`info`,`movie_id`);
ALTER TABLE `title` ADD INDEX `title_idx_kind_id` (`kind_id`);
SELECT
DISTINCT title.id,
title.title,
title.production_year
FROM
title
WHERE
(
title LIKE 'a%'
AND title.kind_id = 1
)
AND (
EXISTS (
SELECT
1
FROM
movie_info
WHERE
(
movie_info.movie_id = title.id
AND movie_info.info_type_id = 8
AND movie_info.info = 'USA'
)
)
) LIMIT 75