Planner — IMDB — JOB-19D

SELECT MIN(n.name) AS voicing_actress,
       MIN(t.title) AS jap_engl_voiced_movie
FROM job.aka_name AS an,
     job.char_name AS chn,
     job.cast_info AS ci,
     job.company_name AS cn,
     job.info_type AS it,
     job.movie_companies AS mc,
     job.movie_info AS mi,
     job.name AS n,
     job.role_type AS rt,
     job.title AS t
WHERE ci.note IN ('(voice)',
                  '(voice: Japanese version)',
                  '(voice) (uncredited)',
                  '(voice: English version)')
  AND cn.country_code ='[us]'
  AND it.info = 'release dates'
  AND n.gender ='f'
  AND rt.role ='actress'
  AND t.production_year > 2000
  AND t.id = mi.movie_id
  AND t.id = mc.movie_id
  AND t.id = ci.movie_id
  AND mc.movie_id = ci.movie_id
  AND mc.movie_id = mi.movie_id
  AND mi.movie_id = ci.movie_id
  AND cn.id = mc.company_id
  AND it.id = mi.info_type_id
  AND n.id = ci.person_id
  AND rt.id = ci.role_id
  AND n.id = an.person_id
  AND ci.person_id = an.person_id
  AND chn.id = ci.person_role_id;

Engine Compare

Accuracy chart, rows processed ?
Scan Scan	Seek Seek	Join Probe Join	Sort Sort	Hash Build Hash	Aggregate Agg	Distribute Dist
Estimation Error Est Err 22,357,952 22M Rank		Estimation Error Est Err 28,430,665 28M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 13,347,883 13M Rank	Estimation Error Est Err 1,760,645 1.8M Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 60,073,885 60M Rank		Estimation Error Est Err 87,325,444 87M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 49,651,005 50M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 12,693,346 13M Rank		Estimation Error Est Err 35,235,875 35M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 20,445,744 20M Rank	Estimation Error Est Err 1,760,646 1.8M Rank	Estimation Error Est Err 4,337,964 4.3M Rank
Estimation Error Est Err 21,267,066 21M Rank		Estimation Error Est Err 18,783,794 19M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 18,299,304 18M Rank	Estimation Error Est Err 1,760,655 1.8M Rank	Estimation Error Est Err 18,151,837 18M Rank
Estimation Error Est Err 5,220,954 5.2M Rank		Estimation Error Est Err 10,331,312 10M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 9,161,913 9.2M Rank	Estimation Error Est Err 1,760,645 1.8M Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 19,425,378 19M Rank	Estimation Error Est Err 19,425,377 19M Rank	Estimation Error Est Err 24,243,954 24M Rank	Estimation Error Est Err 1,725,985 1.7M Rank	Estimation Error Est Err 19,535,271 20M Rank	Estimation Error Est Err 1,760,650 1.8M Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 5,336,698 5.3M Rank	Estimation Error Est Err 4,935,284 4.9M Rank	Estimation Error Est Err 12,489,934 12M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 14,589,967 15M Rank	Estimation Error Est Err 1,920,398 1.9M Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 11,036,817 11M Rank		Estimation Error Est Err 15,743,193 16M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 18,711,147 19M Rank	Estimation Error Est Err 1,760,661 1.8M Rank	Estimation Error Est Err 10,760,667 11M Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min 161 1760645 INNER JOIN HASH ON id29 = person_id85 636 787043 │└INNER JOIN HASH ON id74 = company_id 658 3229056 │ │└INNER JOIN HASH ON id41 = movie_id67 552 341836 │ │ │└INNER JOIN HASH ON id56 = person_role_id 578 341836 │ │ │ │└INNER JOIN HASH ON id41 = movie_id22 1994 498048 │ │ │ │ │└INNER JOIN HASH ON id29 = person_id 8058 498436 │ │ │ │ │ │└INNER JOIN HASH ON movie_id22 = movie_id 74487 255651 │ │ │ │ │ │ │└INNER JOIN HASH ON id = role_id 1 1 │ │ │ │ │ │ │ │└TABLE SCAN role_type WHERE role = actress 707897 801259 │ │ │ │ │ │ │ TABLE SCAN cast_info WHERE note IN(voice,voice uncredited,(voice : English version),(voice : Japanese version)) 131290 3036719 │ │ │ │ │ │ INNER JOIN HASH ON id16 = info_type_id 1 1 │ │ │ │ │ │ │└TABLE SCAN info_type WHERE info = release dates 14835720 14835720 │ │ │ │ │ │ TABLE SCAN movie_info 931987 23428 │ │ │ │ │ TABLE SCAN name WHERE gender = f 1402423 42260 │ │ │ │ TABLE SCAN title WHERE production_year >= 2001 3140339 3140339 │ │ │ TABLE SCAN char_name 2609129 2609129 │ │ TABLE SCAN movie_companies 90648 4472 │ TABLE SCAN company_name WHERE country_code = us 901343 901343 TABLE SCAN aka_name
	Estimate Actual Operator - 1 PROJECT a1 AS voicing_actress, a2 AS jap_engl_voiced_movie - 1 AGGREGATE MIN(name) AS a1, MIN(title) AS a2 - 0 PROJECT name, title - 0 PROJECT name, title - 0 INNER JOIN HASH ON tuple(PROJECTION_1795.movie_id,PROJECTION_1795.movie_id,PROJECTION_1795.movie_id) = tuple(PROJECTION_1768.movie_id,PROJECTION_1768.movie_id,PROJECTION_1768.id) - 0 │└PROJECT movie_id_right, movie_id AS movie_id_right_2, id, title - 0 │ PROJECT movie_id, movie_id, title, id - 0 │ INNER JOIN HASH ON PROJECTION_1792.id = PROJECTION_1771.company_id - 6621484 │ │└PROJECT company_id, movie_id, movie_id, title, id AS id_right - 6621484 │ │ PROJECT movie_id, company_id, movie_id, title, id - 6621484 │ │ INNER JOIN HASH ON tuple(PROJECTION_1789.movie_id,PROJECTION_1789.movie_id) = tuple(PROJECTION_1774.movie_id,PROJECTION_1774.id) - 1798330 │ │ │└PROJECT movie_id AS movie_id_right, id, title - 1798330 │ │ │ PROJECT movie_id, title, id - 1798330 │ │ │ INNER JOIN HASH ON PROJECTION_1786.id = PROJECTION_1777.movie_id - 3036719 │ │ │ │└PROJECT movie_id - 3036719 │ │ │ │ PROJECT movie_id - 3036719 │ │ │ │ INNER JOIN HASH ON PROJECTION_1783.info_type_id = PROJECTION_1780.id - 1 │ │ │ │ │└PROJECT id - 1 │ │ │ │ │ PROJECT id - 1 │ │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates' - 14835720 │ │ │ │ PROJECT info_type_id, movie_id - 14835720 │ │ │ │ PROJECT movie_id, info_type_id - 14835720 │ │ │ │ TABLE SCAN movie_info - 1381453 │ │ │ PROJECT id, title - 1381453 │ │ │ PROJECT id, title - 1381453 │ │ │ TABLE SCAN title WHERE production_year > 2000 - 2609129 │ │ PROJECT movie_id AS movie_id_left, company_id - 2609129 │ │ PROJECT movie_id, company_id - 2609129 │ │ TABLE SCAN movie_companies - 0 │ PROJECT id AS id_left - 0 │ PROJECT id - 0 │ TABLE SCAN company_name WHERE country_code = 'us' - 6552142 PROJECT movie_id AS movie_id_left, name - 6552142 PROJECT movie_id, name - 6552142 INNER JOIN HASH ON tuple(PROJECTION_1819.id,PROJECTION_1819.id) = tuple(PROJECTION_1798.person_id,PROJECTION_1798.person_id) - 6559938 │└PROJECT person_id, person_id, movie_id - 6559938 │ PROJECT person_id, person_id, movie_id - 6559938 │ INNER JOIN HASH ON PROJECTION_1816.id = PROJECTION_1801.person_role_id - 8161344 │ │└PROJECT person_role_id, person_id, person_id, movie_id - 8161344 │ │ PROJECT person_id, person_id, person_role_id, movie_id - 8161344 │ │ INNER JOIN HASH ON PROJECTION_1813.person_id = PROJECTION_1804.person_id - 7451973 │ │ │└PROJECT person_id AS person_id_right, person_role_id, movie_id - 7451973 │ │ │ PROJECT person_id, person_role_id, movie_id - 7451973 │ │ │ INNER JOIN HASH ON PROJECTION_1810.role_id = PROJECTION_1807.id - 1 │ │ │ │└PROJECT id - 1 │ │ │ │ PROJECT id - 1 │ │ │ │ TABLE SCAN role_type WHERE role = 'actress' - 36244344 │ │ │ PROJECT role_id, person_id, person_role_id, movie_id - 36244344 │ │ │ PROJECT person_id, person_role_id, movie_id, role_id - 36244344 │ │ │ TABLE SCAN cast_info WHERE TRUE - 901343 │ │ PROJECT person_id AS person_id_left - 901343 │ │ PROJECT person_id - 901343 │ │ TABLE SCAN aka_name - 3140339 │ PROJECT id - 3140339 │ PROJECT id - 3140339 │ TABLE SCAN char_name - 961555 PROJECT id, name - 961555 PROJECT id, name - 961555 TABLE SCAN name WHERE gender = 'f'
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1) 13 1760645 PROJECT name, title 13 1760645 INNER JOIN HASH ON id = person_role_id 13 1909379 │└INNER JOIN HASH ON info_type_id = id 2 1 │ │└FILTER id <= 110 2 1 │ │ TABLE SCAN info_type WHERE info = 'release dates' 784 1909379 │ INNER JOIN HASH ON movie_id = movie_id 131 276408 │ │└INNER JOIN HASH ON id = person_id 226 276501 │ │ │└INNER JOIN HASH ON person_id = person_id 903 104391 │ │ │ │└INNER JOIN HASH ON role_id = id 1 1 │ │ │ │ │└FILTER id <= 11 1 1 │ │ │ │ │ TABLE SCAN role_type WHERE role = 'actress' 10844 104391 │ │ │ │ INNER JOIN HASH ON movie_id = id 3716 468787 │ │ │ │ │└INNER JOIN HASH ON id = movie_id 18253 1153798 │ │ │ │ │ │└INNER JOIN HASH ON company_id = id 1644 84843 │ │ │ │ │ │ │└TABLE SCAN company_name WHERE country_code = 'us' 2609129 2609129 │ │ │ │ │ │ TABLE SCAN movie_companies 505662 1381089 │ │ │ │ │ FILTER id BETWEEN 2 AND 2525745 505662 1381453 │ │ │ │ │ TABLE SCAN title WHERE production_year > 2000 7248868 48105 │ │ │ │ FILTER (person_id >= 4) AND (movie_id BETWEEN 2 AND 2525745) 7248868 48105 │ │ │ │ FILTER (note = '(voice)') OR (note = '(voice: Japanese version)') OR (note = '(voice) (uncredited)') OR (note = '(voice: English version)') 36244344 1090876 │ │ │ │ TABLE SCAN cast_info WHERE note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)') 901343 7044 │ │ │ TABLE SCAN aka_name WHERE person_id <= 4061926 2083746 3547 │ │ FILTER id BETWEEN 4 AND 4061926 2083746 3547 │ │ TABLE SCAN "name" WHERE gender = 'f' 14835720 34039 │ TABLE SCAN movie_info WHERE movie_id >= 2 AND movie_id <= 2525745 3140339 10021 TABLE SCAN char_name
	Estimate Actual Operator 1 1 PROJECT voicing_actress, jap_engl_voiced_movie 1 1 AGGREGATE MIN(name), MIN(title) 111284 10 DISTRIBUTE GATHER 111284 10 AGGREGATE MIN(name), MIN(title) 111284 1760645 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id 111284 2711062 │└DISTRIBUTE GATHER 111284 2711062 │ INNER JOIN HASH ON id = role_id 3 1 │ │└DISTRIBUTE GATHER 3 1 │ │ FILTER role = 'actress' 12 12 │ │ DISTRIBUTE ROUND ROBIN 12 12 │ │ TABLE SCAN role_type WHERE role = 'actress' 408043 2711062 │ INNER JOIN HASH ON person_id = id AND person_id = id 408043 2744644 │ │└DISTRIBUTE HASH ON person_id, person_id 408043 2744644 │ │ INNER JOIN HASH ON id = info_type_id 23 1 │ │ │└DISTRIBUTE GATHER 23 1 │ │ │ FILTER info = 'release dates' 113 113 │ │ │ DISTRIBUTE ROUND ROBIN 113 113 │ │ │ TABLE SCAN info_type WHERE info = 'release dates' 1951510 2869588 │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id 332330 490029 │ │ │└DISTRIBUTE HASH ON movie_id, movie_id 332330 490029 │ │ │ INNER JOIN HASH ON id = company_id 47000 84843 │ │ │ │└DISTRIBUTE GATHER 47000 84843 │ │ │ │ FILTER country_code = 'us' 234997 234997 │ │ │ │ TABLE SCAN company_name WHERE country_code = 'us' 1661629 930328 │ │ │ PROJECT person_id, person_id, movie_id, role_id, movie_id, company_id 1661629 930328 │ │ │ INNER JOIN HASH ON movie_id = movie_id 2609129 2609129 │ │ │ │└DISTRIBUTE HASH ON movie_id 2609129 2609129 │ │ │ │ TABLE SCAN movie_companies WHERE ((company_id >= 1) AND (company_id <= 234997)) AND TRUE 1608526 497319 │ │ │ DISTRIBUTE HASH ON movie_id 1608526 497319 │ │ │ INNER JOIN HASH ON person_role_id = id 1608526 517803 │ │ │ │└DISTRIBUTE HASH ON person_role_id 1608526 517803 │ │ │ │ INNER JOIN HASH ON person_id = person_id 901343 901343 │ │ │ │ │└DISTRIBUTE HASH ON person_id 901343 901343 │ │ │ │ │ TABLE SCAN aka_name 7248869 280995 │ │ │ │ DISTRIBUTE HASH ON person_id 7248869 280995 │ │ │ │ FILTER note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)') 36244344 7656546 │ │ │ │ TABLE SCAN cast_info WHERE ((note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)') AND CASE MOD(HASH_REPARTITION person_id,10) WHEN 0 THEN (((person_id >= 5) AND (person_id <= 4167489)) AND TRUE) WHEN 1 THEN (((person_id >= 15) AND (person_id <= 4167473)) AND TRUE) WHEN 2 THEN (((person_id >= 69) AND (person_id <= 4167478)) AND TRUE) WHEN 3 THEN (((person_id >= 161) AND (person_id <= 4167352)) AND TRUE) WHEN 4 THEN... 3140339 3140339 │ │ │ DISTRIBUTE HASH ON id 3140339 3140339 │ │ │ TABLE SCAN char_name WHERE CASE MOD(HASH_REPARTITION id,10) WHEN 0 THEN (((id >= 119) AND (id <= 3139884)) AND TRUE) WHEN 1 THEN (((id >= 63) AND (id <= 3139863)) AND TRUE) WHEN 2 THEN (((id >= 53) AND (id <= 3139889)) AND TRUE) WHEN 3 THEN (((id >= 1) AND (id <= 3139888)) AND TRUE) WHEN 4 THEN (((id >= 21) AND (id <= 3139890)) AND TRUE) WHEN 5 THEN (((id >= 57) AND (id <= 3139914)) AND TRUE) WHEN 6 THEN (((id >= 142) AND (id <= 3139883)) AND TRUE) WHEN 7 THEN ... 14835720 3212639 │ │ DISTRIBUTE HASH ON movie_id, movie_id 14835720 3212639 │ │ TABLE SCAN movie_info WHERE CASE MOD(HASH_REPARTITION(movie_id,movie_id),10) WHEN 1 THEN ((((movie_id >= 908) AND (movie_id <= 2525701)) AND ((movie_id >= 908) AND (movie_id <= 2525701))) AND TRUE) WHEN 3 THEN ((((movie_id >= 909) AND (movie_id <= 2525698)) AND ((movie_id >= 909) AND (movie_id <= 2525698))) AND TRUE) WHEN 5 THEN ((((movie_id >= 910) AND (movie_id <= 2525691)) AND ((movie_id >= 910) AND (movie_id <= 2525691))) AND TRUE) WHEN 7 THEN ((((movie_id >= 9... 833499 961555 │ DISTRIBUTE HASH ON id, id 833499 961555 │ FILTER gender = 'f' 4167491 983636 │ TABLE SCAN name WHERE (gender = 'f') AND CASE MOD(HASH_REPARTITION(id,id),10) WHEN 1 THEN ((((id >= 293010) AND (id <= 2700427)) AND ((id >= 293010) AND (id <= 2700427))) AND TRUE) WHEN 3 THEN ((((id >= 4453) AND (id <= 2698015)) AND ((id >= 4453) AND (id <= 2698015))) AND TRUE) WHEN 5 THEN ((((id >= 1728587) AND (id <= 2700464)) AND ((id >= 1728587) AND (id <= 2700464))) AND TRUE) WHEN 7 THEN ((((id >= 1728872) AND (id <= 2700366)) AND ((id >= 1728872) AND (id <= 2700... 343129 1381453 FILTER production_year > 2000 2528312 2528312 TABLE SCAN title WHERE (production_year > 2000) AND (((((id >= 908) AND (id <= 2525702)) AND ((id >= 908) AND (id <= 2525702))) AND ((id >= 908) AND (id <= 2525702))) AND TRUE)
	Estimate Actual Operator 1 1 AGGREGATE MIN(n.name), MIN(t.title) 1 1 DISTRIBUTE GATHER 1 1 AGGREGATE MIN(n.name), MIN(t.title) 3830 1760645 INNER JOIN HASH ON ci.movie_id = mc.movie_id 3830 290297 │└DISTRIBUTE GATHER 150 290297 │ INNER JOIN HASH ON ci.person_id = an.person_id 150 159307 │ │└DISTRIBUTE GATHER 142 159307 │ │ INNER JOIN HASH ON ci.movie_id = t.id 142 255493 │ │ │└DISTRIBUTE GATHER 12100 255493 │ │ │ INNER JOIN HASH ON ci.person_id = n.id 12100 255651 │ │ │ │└DISTRIBUTE GATHER 519000 255651 │ │ │ │ INNER JOIN HASH ON ci.person_role_id = chn.id 519000 255651 │ │ │ │ │└DISTRIBUTE GATHER 203000 255651 │ │ │ │ │ INNER JOIN HASH ON ci.role_id = rt.id 203000 1 │ │ │ │ │ │└DISTRIBUTE GATHER 235000 1 │ │ │ │ │ │ TABLE SCAN role_type WHERE rt.role = 'actress' 2610000 255651 │ │ │ │ │ TABLE SCAN cast_info WHERE (ci.note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)')) AND (ci.person_role_id IS NOT NULL) 113 3132421 │ │ │ │ TABLE SCAN char_name 901000 956453 │ │ │ TABLE SCAN name WHERE (n.gender IS NOT NULL) AND (n.gender = 'f') 4170000 1377105 │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year > 2000L) 36200000 897289 │ TABLE SCAN aka_name 238 3437396 INNER JOIN HASH ON mc.company_id = cn.id 238 84843 │└DISTRIBUTE GATHER 3140000 84843 │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND (cn.country_code = 'us') 142 10898241 INNER JOIN HASH ON mi.movie_id = mc.movie_id 142 3036719 │└DISTRIBUTE GATHER 142 3036719 │ INNER JOIN HASH ON mi.info_type_id = it.id 142 1 │ │└DISTRIBUTE GATHER 14800000 1 │ │ TABLE SCAN info_type WHERE it.info = 'release dates' 2530000 3383078 │ TABLE SCAN movie_info 12 2606504 TABLE SCAN movie_companies
	Estimate Actual Operator 1 1 AGGREGATE MIN(partialagg1090) AS Expr1020, MIN(partialagg1091) AS Expr1021 203 10024 INNER JOIN LOOP ON ci.person_role_id = chn.id 1 10024 │└TABLE SEEK char_name AS chn 207 10025 AGGREGATE MIN(name as name) AS partialagg1090, MIN(title as title) AS partialagg1091 GROUP BY HASH person_role_id 29251 1910374 INNER JOIN HASH ON mc.company_id = cn.id 84576 84843 │└TABLE SCAN company_name AS cn WHERE country_code as country_code = 'us' 81336 1910374 INNER JOIN HASH ON mc.movie_id = t.id 8212 741702 │└INNER JOIN LOOP ON Bmk1018 = Bmk1018 0 741702 │ │└TABLE SEEK title AS t WHERE production_year as production_year > 2000 15112 1131685 │ PROJECT BmkToPage Bmk1018 AS Expr1814 15112 1131685 │ INNER JOIN LOOP ON mi.movie_id = t.id 1 1131685 │ │└TABLE SEEK title AS t 15112 1131685 │ INNER JOIN HASH ON n.id = ci.person_id 67623 1132447 │ │└INNER JOIN HASH ON an.person_id = ci.person_id 13936 547464 │ │ │└INNER JOIN HASH ON ci.role_id = rt.id 1 1 │ │ │ │└FILTER role as role = 'actress' 12 12 │ │ │ │ INNER JOIN LOOP ON Bmk1016 = Bmk1016 1 12 │ │ │ │ │└TABLE SEEK role_type AS rt 12 12 │ │ │ │ TABLE SEEK role_type AS rt 15330 547464 │ │ │ INNER JOIN HASH ON ci.movie_id = mi.movie_id 211939 3036719 │ │ │ │└INNER JOIN LOOP ON it.id = mi.info_type_id 211939 3036719 │ │ │ │ │└TABLE SEEK movie_info AS mi 1 1 │ │ │ │ FILTER info as info = 'release dates' 113 113 │ │ │ │ TABLE SCAN info_type AS it 8675 259680 │ │ │ TABLE SCAN cast_info AS ci WHERE (note as note = '(voice)' OR note as note = '(voice) (uncredited)' OR note as note = '(voice: English version)' OR note as note = '(voice: Japanese version)') AND BLOOM(role_id as role_id) AND BLOOM(movie_id as movie_id) 90134 15130 │ │ TABLE SEEK aka_name AS an WHERE BLOOM(person_id as person_id) 931 8116 │ TABLE SCAN name AS n WHERE gender as gender = 'f' AND BLOOM(id as id) 2609130 18796 FILTER BLOOM(company_id as company_id) 2609130 48662 TABLE SCAN movie_companies AS mc WHERE PROBE(Bitmap1816,movie_id as movie_id,N'IN ROW')
	Estimate Actual Operator 1 ∞ PROJECT min AS voicing_actress, min_61 AS jap_engl_voiced_movie 1 1 AGGREGATE MIN(min_62) AS min, MIN(min_63) AS min_61 - 16 DISTRIBUTE GATHER - 16 AGGREGATE MIN(name_40) AS min_62, MIN(title) AS min_63 - 1760645 INNER JOIN HASH ON movie_id = id_54 335742 1381453 │└DISTRIBUTE HASH ON id_54 335742 1381453 │ PROJECT id AS id_54, title 335742 1381453 │ FILTER production_year > 2000 335742 1381453 │ TABLE SCAN title - 2711062 INNER JOIN HASH ON role_id = id_50 12 1 │└DISTRIBUTE GATHER 12 1 │ PROJECT id AS id_50 12 1 │ FILTER role = 'actress' 12 1 │ TABLE SCAN role_type - 2711062 INNER JOIN HASH ON person_id_10 = id_39 4167491 961555 │└DISTRIBUTE HASH ON id_39 4167491 961555 │ PROJECT id AS id_39, name AS name_40 4167491 961555 │ FILTER gender = 'f' 4167491 961555 │ TABLE SCAN name - 2712382 INNER JOIN HASH ON info_type_id = id_22 113 1 │└DISTRIBUTE GATHER 113 1 │ PROJECT id AS id_22 113 1 │ FILTER info = 'release dates' 113 1 │ TABLE SCAN info_type - 2817577 INNER JOIN HASH ON movie_id = movie_id_33 14835720 3137318 │└DISTRIBUTE HASH ON movie_id_33 14835720 3137318 │ PROJECT movie_id AS movie_id_33, info_type_id 14835720 3137318 │ TABLE SCAN movie_info - 483198 INNER JOIN HASH ON company_id = id_14 234997 84843 │└DISTRIBUTE GATHER 234997 84843 │ PROJECT id AS id_14 234997 84843 │ FILTER country_code = 'us' 234997 84843 │ TABLE SCAN company_name - 483198 INNER JOIN HASH ON movie_id = movie_id_27 2609129 1153798 │└DISTRIBUTE HASH ON movie_id_27 2609129 1153798 │ PROJECT movie_id AS movie_id_27, company_id 2609129 1153798 │ TABLE SCAN movie_companies - 483319 INNER JOIN HASH ON person_role_id = id_0 3140339 3140339 │└DISTRIBUTE HASH ON id_0 3140339 3140339 │ PROJECT id AS id_0 3140339 3140339 │ TABLE SCAN char_name - 503508 INNER JOIN HASH ON person_id_10 = person_id 901343 901343 │└DISTRIBUTE GATHER 901343 901343 │ TABLE SCAN aka_name 32619910 276166 PROJECT person_id AS person_id_10, movie_id, person_role_id, role_id 32619910 276166 FILTER note IN('(voice)','(voice) (uncredited)','(voice: English version)','(voice: Japanese version)') 32619910 276166 TABLE SCAN cast_info
	Estimate Actual Operator 1 1 AGGREGATE MIN(name), MIN(title) 5 5 AGGREGATE PARTIAL MIN(name), PARTIAL MIN(title) 7335 1760645 INNER JOIN LOOP ON id = company_id 20090 6023690 │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 3945 702993 │ │└INNER JOIN LOOP ON id = person_role_id 789 148285 │ │ │└INNER JOIN HASH ON info_type_id = id 5 5 │ │ │ │└TABLE SEEK info_type AS it 445980 3670421 │ │ │ INNER JOIN LOOP ON movie_id = id 27505 298569 │ │ │ │└INNER JOIN LOOP ON id = movie_id 50550 503022 │ │ │ │ │└INNER JOIN LOOP ON id = person_id 219595 503508 │ │ │ │ │ │└INNER JOIN MERGE ON person_id = person_id 1126680 578832 │ │ │ │ │ │ │└TABLE SEEK aka_name AS an 361600 1725985 │ │ │ │ │ │ SORT person_id 361600 1380830 │ │ │ │ │ │ INNER JOIN LOOP ON role_id = id 1 1 │ │ │ │ │ │ │└TABLE SCAN role_type AS rt WHERE rt.role = 'actress' 394475 1380830 │ │ │ │ │ │ TABLE SEEK cast_info AS ci WHERE ci.note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)') 503508 503508 │ │ │ │ │ TABLE SEEK name AS n WHERE n.gender = 'f' 503022 503022 │ │ │ │ TABLE SEEK title AS t WHERE t.production_year > 2000 11942760 3669413 │ │ │ TABLE SEEK movie_info AS mi 741427 741427 │ │ TABLE SEEK char_name AS chn 3514965 6024650 │ TABLE SEEK movie_companies AS mc 6023690 6023690 TABLE SEEK company_name AS cn WHERE cn.country_code = 'us'