Planner — IMDB — JOB-19C

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 mi.info IS NOT NULL
  AND (mi.info LIKE 'Japan:%200%'
       OR mi.info LIKE 'USA:%200%')
  AND n.gender ='f'
  AND n.name LIKE '%An%'
  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 6,959,612 7M Rank		Estimation Error Est Err 6,921,352 6.9M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 89,758 90K Rank	Estimation Error Est Err 3,575 3.6K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 44,777,725 45M Rank		Estimation Error Est Err 0 Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 0 Rank	Estimation Error Est Err 0 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 8,849,320 8.8M Rank		Estimation Error Est Err 10,077,635 10M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 2,546,244 2.5M Rank	Estimation Error Est Err 3,576 3.6K Rank	Estimation Error Est Err 1,060,925 1.1M Rank
Estimation Error Est Err 21,267,066 21M Rank		Estimation Error Est Err 7,713,090 7.7M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 5,631,911 5.6M Rank	Estimation Error Est Err 3,585 3.6K Rank	Estimation Error Est Err 9,334,776 9.3M Rank
Estimation Error Est Err 4,917,089 4.9M Rank		Estimation Error Est Err 5,324,677 5.3M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 4,255,017 4.3M Rank	Estimation Error Est Err 3,575 3.6K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 150,691 151K Rank	Estimation Error Est Err 100,679 101K Rank	Estimation Error Est Err 112,603 113K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 99,621 100K Rank	Estimation Error Est Err 3,580 3.6K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 20,799,323 21M Rank	Estimation Error Est Err 20,799,198 21M Rank	Estimation Error Est Err 28,260,592 28M Rank	Estimation Error Est Err 726,651 727K Rank	Estimation Error Est Err 30,718,555 31M Rank	Estimation Error Est Err 70,027 70K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 6,275,328 6.3M Rank		Estimation Error Est Err 57,292 57K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 6,280,234 6.3M Rank	Estimation Error Est Err 3,591 3.6K Rank	Estimation Error Est Err 6,272,026 6.3M Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min 210 3575 INNER JOIN HASH ON person_id = person_id85 216 2632 │└INNER JOIN HASH ON id = info_type_id 1 1 │ │└TABLE SCAN info_type WHERE info = release dates 216 2632 │ INNER JOIN HASH ON id74 = person_role_id 226 2632 │ │└INNER JOIN HASH ON id64 = company_id 347 8585 │ │ │└INNER JOIN HASH ON id41 = movie_id57 291 2129 │ │ │ │└INNER JOIN HASH ON id41 = movie_id 375 2366 │ │ │ │ │└INNER JOIN HASH ON movie_id34 = movie_id 1207 5686 │ │ │ │ │ │└INNER JOIN HASH ON id6 = role_id 1 1 │ │ │ │ │ │ │└TABLE SCAN role_type WHERE role = actress 11474 5686 │ │ │ │ │ │ INNER JOIN HASH ON id11 = person_id 61047 50011 │ │ │ │ │ │ │└TABLE SCAN name WHERE gender = f AND name LIKE '%An%' 707897 255096 │ │ │ │ │ │ TABLE SCAN cast_info WHERE note IN(voice,voice uncredited,(voice : English version),(voice : Japanese version)) 376688 1890 │ │ │ │ │ TABLE SCAN movie_info WHERE info36 LIKE '%200%' 1402423 1355 │ │ │ │ TABLE SCAN title WHERE production_year >= 2001 2609129 2609129 │ │ │ TABLE SCAN movie_companies 90648 447 │ │ TABLE SCAN company_name WHERE country_code = us 3140339 3140339 │ TABLE SCAN char_name 901343 901343 TABLE SCAN aka_name
	Estimate Actual Operator - ∞ PROJECT a1 AS voicing_actress, a2 AS jap_engl_voiced_movie - ∞ AGGREGATE MIN(name) AS a1, MIN(title) AS a2 - ∞ PROJECT name, title - ∞ PROJECT name, title - ∞ INNER JOIN HASH ON tuple(PROJECTION_1736.movie_id,PROJECTION_1736.movie_id,PROJECTION_1736.movie_id) = tuple(PROJECTION_1709.movie_id,PROJECTION_1709.movie_id,PROJECTION_1709.id) - ∞ │└PROJECT movie_id_right, movie_id AS movie_id_right_2, id, title - ∞ │ PROJECT movie_id, movie_id, title, id - ∞ │ INNER JOIN HASH ON tuple(PROJECTION_1733.id,PROJECTION_1733.id) = tuple(PROJECTION_1712.movie_id,PROJECTION_1712.movie_id) - ∞ │ │└PROJECT movie_id, movie_id - ∞ │ │ PROJECT movie_id, movie_id - ∞ │ │ INNER JOIN HASH ON PROJECTION_1730.id = PROJECTION_1715.company_id - ∞ │ │ │└PROJECT company_id, movie_id, movie_id - ∞ │ │ │ PROJECT movie_id, company_id, movie_id - ∞ │ │ │ INNER JOIN HASH ON PROJECTION_1727.movie_id = PROJECTION_1718.movie_id - ∞ │ │ │ │└PROJECT movie_id AS movie_id_right - ∞ │ │ │ │ PROJECT movie_id - ∞ │ │ │ │ INNER JOIN HASH ON PROJECTION_1724.info_type_id = PROJECTION_1721.id - 1 │ │ │ │ │└PROJECT id - 1 │ │ │ │ │ FILTER (1 AND info = 'release dates'_String) AS a51 - 1 │ │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates' - ∞ │ │ │ │ PROJECT info_type_id, movie_id - ∞ │ │ │ │ FILTER (1 AND OR ( LIKE (info,'Japan:%200%'_String), LIKE (info,'USA:%200%'_String))) AS a43 - 451104 │ │ │ │ TABLE SCAN movie_info WHERE info LIKE 'Japan:%200%' OR info LIKE 'USA:%200%' - 2609129 │ │ │ PROJECT movie_id AS movie_id_left, company_id - 2609129 │ │ │ PROJECT movie_id, company_id - 2609129 │ │ │ TABLE SCAN movie_companies - 0 │ │ PROJECT id - 0 │ │ FILTER (1 AND country_code = 'us'_String) AS a37 - 0 │ │ TABLE SCAN company_name WHERE country_code = 'us' - 1381453 │ PROJECT id, title - 1381453 │ FILTER (1 AND production_year > 2000_UInt16) AS a32 - 1381453 │ TABLE SCAN title WHERE production_year > 2000 - ∞ PROJECT movie_id AS movie_id_left, name - ∞ PROJECT movie_id, name - ∞ INNER JOIN HASH ON PROJECTION_1760.id = PROJECTION_1739.person_role_id - ∞ │└PROJECT person_role_id, movie_id, name - ∞ │ PROJECT person_role_id, movie_id, name - ∞ │ INNER JOIN HASH ON tuple(PROJECTION_1757.person_id,PROJECTION_1757.person_id) = tuple(PROJECTION_1742.person_id,PROJECTION_1742.id) - ∞ │ │└PROJECT person_id AS person_id_right, id, person_role_id, movie_id, name - ∞ │ │ PROJECT person_id, person_role_id, movie_id, name, id - ∞ │ │ INNER JOIN HASH ON PROJECTION_1754.id = PROJECTION_1745.person_id - ∞ │ │ │└PROJECT person_id, person_role_id, movie_id - ∞ │ │ │ PROJECT person_id, person_role_id, movie_id - ∞ │ │ │ INNER JOIN HASH ON PROJECTION_1751.role_id = PROJECTION_1748.id - 1 │ │ │ │└PROJECT id - 1 │ │ │ │ FILTER (1 AND role = 'actress'_String) AS a25 - 1 │ │ │ │ TABLE SCAN role_type WHERE role = 'actress' - ∞ │ │ │ PROJECT role_id, person_id, person_role_id, movie_id - ∞ │ │ │ FILTER (in(note,__set_String_6680244196204786103_17565861716447275384) AND 1) AS a21 - 36244344 │ │ │ TABLE SCAN cast_info WHERE TRUE - ∞ │ │ PROJECT id, name - ∞ │ │ FILTER (1 AND LIKE (name,'%An%'_String) AND gender = 'f'_String) AS a12 - 50011 │ │ TABLE SCAN name WHERE (gender = 'f') AND name LIKE '%An%' - 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
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1) 2 3575 PROJECT name, title 2 3575 INNER JOIN HASH ON id = person_role_id 2 3744 │└INNER JOIN HASH ON id = person_id 4 279966 │ │└INNER JOIN HASH ON person_id = person_id 19 132216 │ │ │└INNER JOIN HASH ON role_id = id 1 1 │ │ │ │└FILTER id <= 11 1 1 │ │ │ │ TABLE SCAN role_type WHERE role = 'actress' 229 132216 │ │ │ INNER JOIN HASH ON movie_id = id 78 391371 │ │ │ │└INNER JOIN HASH ON info_type_id = id 2 1 │ │ │ │ │└FILTER id <= 110 2 1 │ │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates' 4439 391371 │ │ │ │ INNER JOIN HASH ON movie_id = movie_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 2967144 184372 │ │ │ │ FILTER movie_id BETWEEN 2 AND 2525745 2967144 184372 │ │ │ │ TABLE SCAN movie_info WHERE (info IS NOT NULL) AND ((info LIKE 'Japan:%200%') OR (info LIKE 'USA:%200%')) 7248868 32923 │ │ │ FILTER (person_id >= 4) AND (movie_id BETWEEN 2 AND 2525745) 7248868 32923 │ │ │ FILTER (note = '(voice)') OR (note = '(voice: Japanese version)') OR (note = '(voice) (uncredited)') OR (note = '(voice: English version)') 36244344 651682 │ │ │ TABLE SCAN cast_info WHERE note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)') 901343 5259 │ │ TABLE SCAN aka_name WHERE person_id <= 4061926 2083746 95 │ FILTER id BETWEEN 4 AND 4061926 2083746 95 │ TABLE SCAN "name" WHERE gender = 'f' AND contains(name,'An') 3140339 254 TABLE SCAN char_name
	Estimate Actual Operator 1 1 PROJECT voicing_actress, jap_engl_voiced_movie 1 1 AGGREGATE MIN(name), MIN(title) 22256 10 DISTRIBUTE GATHER 22256 10 AGGREGATE MIN(name), MIN(title) 22256 3575 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id 22256 4113 │└DISTRIBUTE GATHER 22256 4113 │ 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' 81608 4113 │ INNER JOIN HASH ON person_id = id AND person_id = id 81608 307676 │ │└DISTRIBUTE HASH ON person_id, person_id 81608 307676 │ │ 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' 390302 307676 │ │ 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 ... 2967144 451039 │ │ DISTRIBUTE HASH ON movie_id, movie_id 2967144 451039 │ │ FILTER info IS NOT NULL AND (info LIKE 'Japan:%200%' OR info LIKE 'USA:%200%') 14835720 3212639 │ │ TABLE SCAN movie_info WHERE ((info IS NOT NULL AND (info LIKE 'Japan:%200%' OR info LIKE 'USA:%200%')) AND 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... 833499 50011 │ DISTRIBUTE HASH ON id, id 833499 50011 │ FILTER (gender = 'f') AND name LIKE '%An%' 4167491 983636 │ TABLE SCAN name WHERE ((gender = 'f') AND name LIKE '%An%') 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 >= 1732921) AND (id <= 2698015)) AND ((id >= 1732921) 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 <= 2695816)) AND ((i... 343129 1381453 FILTER production_year > 2000 2528312 2528312 TABLE SCAN title WHERE (production_year > 2000) AND (((((id >= 46880) AND (id <= 2508600)) AND ((id >= 46880) AND (id <= 2508600))) AND ((id >= 46880) AND (id <= 2508600))) 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 3575 INNER JOIN HASH ON ci.movie_id = mc.movie_id 3830 4703 │└DISTRIBUTE GATHER 226 4703 │ INNER JOIN HASH ON ci.person_id = an.person_id 226 3349 │ │└DISTRIBUTE GATHER 142 3349 │ │ INNER JOIN HASH ON ci.movie_id = t.id 142 5686 │ │ │└DISTRIBUTE GATHER 12100 5686 │ │ │ INNER JOIN HASH ON ci.person_id = n.id 12100 255651 │ │ │ │└DISTRIBUTE GATHER 515000 255651 │ │ │ │ INNER JOIN HASH ON ci.person_role_id = chn.id 515000 255651 │ │ │ │ │└DISTRIBUTE GATHER 202000 255651 │ │ │ │ │ INNER JOIN HASH ON ci.role_id = rt.id 202000 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 2530000 49644 │ │ │ TABLE SCAN name WHERE (n.gender IS NOT NULL) AND (n.gender = 'f') AND contains(n.name,'An') 901000 1376967 │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year > 2000L) 36200000 893159 │ TABLE SCAN aka_name 238 424729 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 888431 INNER JOIN HASH ON mi.movie_id = mc.movie_id 142 451039 │└DISTRIBUTE GATHER 901000 451039 │ INNER JOIN HASH ON mi.info_type_id = it.id 901000 1 │ │└DISTRIBUTE GATHER 14800000 1 │ │ TABLE SCAN info_type WHERE it.info = 'release dates' 4170000 451039 │ TABLE SCAN movie_info WHERE mi.info LIKE 'Japan:%200%' OR mi.info LIKE 'USA:%200%' 12 2605594 TABLE SCAN movie_companies
	Estimate Actual Operator 1 1 AGGREGATE MIN(name as name) AS Expr1020, MIN(title as title) AS Expr1021 200 70027 INNER JOIN LOOP ON ci.person_role_id = chn.id 1 70027 │└TABLE SEEK char_name AS chn 444 74233 FILTER country_code as country_code = 'us' 1235 181481 INNER JOIN LOOP ON Bmk1006 = Bmk1006 1 181481 │└TABLE SEEK company_name AS cn 1235 181481 SORT Expr1062 1235 181481 PROJECT BmkToPage Bmk1006 AS Expr1062 1235 181481 INNER JOIN LOOP ON mc.company_id = cn.id 1 181481 │└TABLE SEEK company_name AS cn 1236 181481 SORT company_id 1236 181481 INNER JOIN LOOP ON Bmk1010 = Bmk1010 1 181481 │└TABLE SEEK movie_companies AS mc 1236 181481 SORT Expr1056 1236 181481 PROJECT BmkToPage Bmk1010 AS Expr1056 1236 181481 INNER JOIN LOOP ON t.id = mc.movie_id 9 181481 │└TABLE SEEK movie_companies AS mc 124 60017 INNER JOIN LOOP ON Bmk1018 = Bmk1018 0 60017 │└TABLE SEEK title AS t WHERE production_year as production_year > 2000 229 65232 INNER JOIN LOOP ON ci.movie_id = t.id 1 65232 │└TABLE SEEK title AS t 229 65232 INNER JOIN LOOP ON n.id = an.person_id 4 65232 │└TABLE SEEK aka_name AS an 47 34975 SORT movie_id 47 34975 FILTER name as name LIKE '%An%' AND gender as gender = 'f' 412 147233 INNER JOIN LOOP ON Bmk1014 = Bmk1014 1 147233 │└TABLE SEEK name AS n 412 147233 PROJECT BmkToPage Bmk1014 AS Expr1072 412 147233 INNER JOIN LOOP ON ci.person_id = n.id 1 147233 │└TABLE SEEK name AS n 412 147233 SORT person_id 412 147233 FILTER note as note = '(voice)' OR note as note = '(voice) (uncredited)' OR note as note = '(voice: English version)' OR note as note = '(voice: Japanese version)' 17225 1695931 INNER JOIN LOOP ON Bmk1004 = Bmk1004 1 1695931 │└TABLE SEEK cast_info AS ci 17225 1695931 PROJECT BmkToPage Bmk1004 AS Expr1069 17225 1695931 INNER JOIN HASH ON Bmk1004 = Bmk1004 189484 9919357 │└INNER JOIN LOOP ON mi.movie_id = ci.movie_id 30 9919357 │ │└TABLE SEEK cast_info AS ci 6270 451039 │ INNER JOIN HASH ON mi.info_type_id = it.id 1 1 │ │└FILTER info as info = 'release dates' 113 113 │ │ TABLE SCAN info_type AS it 438927 451039 │ TABLE SEEK movie_info AS mi WHERE (PROBE(Bitmap1066,info_type_id as info_type_id,N'IN ROW')) AND (info as info LIKE 'Japan:%200%' OR info as info LIKE 'USA:%200%') 3294940 7451973 INNER JOIN LOOP ON rt.id = ci.role_id 3294940 7451973 │└TABLE SEEK cast_info AS ci 1 1 FILTER role as role = 'actress' 12 12 TABLE SCAN role_type AS rt
	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 - 3575 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 - 4113 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 - 4113 INNER JOIN HASH ON person_id_10 = id_39 4167491 50011 │└DISTRIBUTE HASH ON id_39 4167491 50011 │ PROJECT id AS id_39, name AS name_40 4167491 50011 │ FILTER (gender = 'f') AND (name LIKE '%An%') 4167491 50011 │ TABLE SCAN name - 4113 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 - 4113 INNER JOIN HASH ON movie_id = movie_id_33 13352148 451039 │└DISTRIBUTE HASH ON movie_id_33 13352148 451039 │ PROJECT movie_id AS movie_id_33, info_type_id 13352148 451039 │ FILTER (((info >= 'Japan:') AND (info < 'Japan;')) OR ((info >= 'USA:') AND (info < 'USA;'))) AND ((info LIKE 'Japan:%200%') OR (info LIKE 'USA:%200%')) 13352148 451039 │ TABLE SCAN movie_info - 8144 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 - 8144 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 - 7726 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 - 8204 INNER JOIN HASH ON person_id_10 = person_id 901343 10525 │└DISTRIBUTE GATHER 901343 10525 │ TABLE SCAN aka_name 32619910 3318 PROJECT person_id AS person_id_10, movie_id, person_role_id, role_id 32619910 3318 FILTER note IN('(voice)','(voice) (uncredited)','(voice: English version)','(voice: Japanese version)') 32619910 3318 TABLE SCAN cast_info
	Estimate Actual Operator 1 1 AGGREGATE MIN(name), MIN(title) 5 5 AGGREGATE PARTIAL MIN(name), PARTIAL MIN(title) 10 3575 INNER JOIN LOOP ON id = company_id 30 11692 │└INNER JOIN LOOP ON movie_id = id 5 3628 │ │└INNER JOIN LOOP ON id = person_role_id 1 743 │ │ │└INNER JOIN HASH ON info_type_id = id 5 5 │ │ │ │└TABLE SEEK info_type AS it 625 3715 │ │ │ INNER JOIN LOOP ON movie_id = id 835 4845 │ │ │ │└INNER JOIN LOOP ON id = movie_id 306 1640 │ │ │ │ │└INNER JOIN HASH ON role_id = id 1 1 │ │ │ │ │ │└TABLE SCAN role_type AS rt WHERE rt.role = 'actress' 18380 8204 │ │ │ │ │ INNER JOIN LOOP ON person_id = person_id AND person_id = id AND (person_id = id) 7860 10525 │ │ │ │ │ │└INNER JOIN LOOP ON person_id = id 36375 50011 │ │ │ │ │ │ │└TABLE SCAN name AS n WHERE (n.name LIKE '%An%') AND (n.gender = 'f') 100022 50011 │ │ │ │ │ │ TABLE SEEK aka_name AS an 126300 10525 │ │ │ │ │ TABLE SEEK cast_info AS ci WHERE ci.note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)') 8204 8204 │ │ │ │ TABLE SEEK title AS t WHERE t.production_year > 2000 9690 4845 │ │ │ TABLE SEEK movie_info AS mi WHERE (mi.info LIKE 'Japan:%200%') OR (mi.info LIKE 'USA:%200%') 3715 3715 │ │ TABLE SEEK char_name AS chn 18140 11682 │ TABLE SEEK movie_companies AS mc 11692 11692 TABLE SEEK company_name AS cn WHERE cn.country_code = 'us'