Planner — IMDB — JOB-29A

SELECT MIN(chn.name) AS voiced_char,
       MIN(n.name) AS voicing_actress,
       MIN(t.title) AS voiced_animation
FROM job.aka_name AS an,
     job.complete_cast AS cc,
     job.comp_cast_type AS cct1,
     job.comp_cast_type AS cct2,
     job.char_name AS chn,
     job.cast_info AS ci,
     job.company_name AS cn,
     job.info_type AS it,
     job.info_type AS it3,
     job.keyword AS k,
     job.movie_companies AS mc,
     job.movie_info AS mi,
     job.movie_keyword AS mk,
     job.name AS n,
     job.person_info AS pi,
     job.role_type AS rt,
     job.title AS t
WHERE cct1.kind ='cast'
  AND cct2.kind ='complete+verified'
  AND chn.name = 'Queen'
  AND ci.note IN ('(voice)',
                  '(voice) (uncredited)',
                  '(voice: English version)')
  AND cn.country_code ='[us]'
  AND it.info = 'release dates'
  AND it3.info = 'trivia'
  AND k.keyword = 'computer-animation'
  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.title = 'Shrek 2'
  AND t.production_year BETWEEN 2000 AND 2010
  AND t.id = mi.movie_id
  AND t.id = mc.movie_id
  AND t.id = ci.movie_id
  AND t.id = mk.movie_id
  AND t.id = cc.movie_id
  AND mc.movie_id = ci.movie_id
  AND mc.movie_id = mi.movie_id
  AND mc.movie_id = mk.movie_id
  AND mc.movie_id = cc.movie_id
  AND mi.movie_id = ci.movie_id
  AND mi.movie_id = mk.movie_id
  AND mi.movie_id = cc.movie_id
  AND ci.movie_id = mk.movie_id
  AND ci.movie_id = cc.movie_id
  AND mk.movie_id = cc.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
  AND n.id = pi.person_id
  AND ci.person_id = pi.person_id
  AND it3.id = pi.info_type_id
  AND k.id = mk.keyword_id
  AND cct1.id = cc.subject_id
  AND cct2.id = cc.status_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 10,998,086 11M Rank		Estimation Error Est Err 11,037,609 11M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 52,835 53K Rank	Estimation Error Est Err 1,620 1.6K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 47,878,621 48M 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 10,319,036 10M Rank		Estimation Error Est Err 11,854,151 12M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 4,826,027 4.8M Rank	Estimation Error Est Err 1,622 1.6K Rank	Estimation Error Est Err 2,552,910 2.6M Rank
Estimation Error Est Err 23,169,616 23M Rank		Estimation Error Est Err 9,090,383 9.1M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 1,083,098 1.1M Rank	Estimation Error Est Err 1,630 1.6K Rank	Estimation Error Est Err 1,950,554 2M Rank
Estimation Error Est Err 595 595 Rank		Estimation Error Est Err 9,772 9.8K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 14,449 14K Rank	Estimation Error Est Err 1,620 1.6K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 8,019 8K Rank	Estimation Error Est Err 8,019 8K Rank	Estimation Error Est Err 8,018 8K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 8,018 8K Rank	Estimation Error Est Err 1,620 1.6K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 9,665 9.7K Rank	Estimation Error Est Err 9,663 9.7K Rank	Estimation Error Est Err 14,718 15K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 11,283 11K Rank	Estimation Error Est Err 1,620 1.6K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 711,989 712K Rank		Estimation Error Est Err 6,675 6.7K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 716,976 717K Rank	Estimation Error Est Err 1,636 1.6K Rank	Estimation Error Est Err 712,004 712K Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min, min 1 1620 INNER JOIN HASH ON id = info_type_id 1 1 │└TABLE SCAN info_type WHERE info = release dates 1 1620 INNER JOIN HASH ON id127 = company_id 1 7128 │└INNER JOIN HASH ON movie_id87 = movie_id120 1 324 │ │└INNER JOIN HASH ON id6 = keyword_id 1 1 │ │ │└TABLE SCAN keyword WHERE keyword = computer - animation 19 34992 │ │ INNER JOIN HASH ON movie_id87 = movie_id114 1 324 │ │ │└INNER JOIN HASH ON id12 = subject_id 1 1 │ │ │ │└TABLE SCAN comp_cast_type WHERE kind = cast 1 324 │ │ │ INNER JOIN HASH ON id17 = info_type_id107 1 1 │ │ │ │└TABLE SCAN info_type WHERE info = trivia 3 978 │ │ │ INNER JOIN HASH ON person_id106 = person_id95 1 6 │ │ │ │└INNER JOIN HASH ON person_id = person_id95 1 2 │ │ │ │ │└INNER JOIN HASH ON id22 = status_id 1 1 │ │ │ │ │ │└TABLE SCAN comp_cast_type WHERE kind = complete + verified 1 2 │ │ │ │ │ INNER JOIN HASH ON movie_id87 = movie_id80 1 1 │ │ │ │ │ │└INNER JOIN HASH ON id32 = movie_id80 1 1 │ │ │ │ │ │ │└INNER JOIN HASH ON id27 = role_id 1 1 │ │ │ │ │ │ │ │└TABLE SCAN role_type WHERE role = actress 1 1 │ │ │ │ │ │ │ INNER JOIN HASH ON id67 = person_id 1 1 │ │ │ │ │ │ │ │└INNER JOIN HASH ON id32 = movie_id 1 3 │ │ │ │ │ │ │ │ │└TABLE SCAN title WHERE production_year BETWEEN 2000 AND 2010 AND title = Shrek 2 1 1 │ │ │ │ │ │ │ │ INNER JOIN HASH ON id47 = person_role_id 1 1 │ │ │ │ │ │ │ │ │└TABLE SCAN char_name WHERE name = Queen 390989 1 │ │ │ │ │ │ │ │ TABLE SCAN cast_info WHERE note IN(voice,voice uncredited,(voice : English version)) 61047 1 │ │ │ │ │ │ │ TABLE SCAN name WHERE gender = f AND name68 LIKE '%An%' 38175 1 │ │ │ │ │ │ TABLE SCAN complete_cast 376688 2 │ │ │ │ │ TABLE SCAN movie_info WHERE info89 LIKE '%200%' 901343 901343 │ │ │ │ TABLE SCAN aka_name 2963664 2963664 │ │ │ TABLE SCAN person_info 4523930 4523930 │ │ TABLE SCAN movie_keyword 2609129 2609129 │ TABLE SCAN movie_companies 90648 5 TABLE SCAN company_name WHERE country_code = us
	Estimate Actual Operator - ∞ PROJECT a1 AS voiced_char, a2 AS voicing_actress, a3 AS voiced_animation - ∞ AGGREGATE MIN(name_left) AS a1, MIN(name_right) AS a2, MIN(title) AS a3 - ∞ PROJECT name_left, name_right, title - ∞ PROJECT name_left, name_right, title - ∞ INNER JOIN HASH ON tuple(PROJECTION_3767.movie_id,PROJECTION_3767.movie_id,PROJECTION_3767.movie_id,PROJECTION_3767.movie_id,PROJECTION_3767.movie_id,PROJECTION_3767.movie_id,PROJECTION_3767.movie_id,PROJECTION_3767.movie_id) = tuple(PROJECTION_3752.movie_id,PROJECTION_3752.movie_id,PROJECTION_3752.movie_id,PROJECTION_3752.movie_id,PROJECTION_3752.id,PROJECTION_3752.id,PROJECTION_3752.id,PROJECTION_3752.id) - 1 │└PROJECT movie_id AS movie_id_right, id, title - 1 │ PROJECT movie_id, title, id - 1 │ INNER JOIN HASH ON PROJECTION_3764.id = PROJECTION_3755.movie_id - 414 │ │└PROJECT movie_id - 414 │ │ PROJECT movie_id - 414 │ │ INNER JOIN HASH ON PROJECTION_3761.keyword_id = PROJECTION_3758.id - 1 │ │ │└PROJECT id - 1 │ │ │ FILTER (1 AND keyword = 'computer-animation'_String) AS a87 - 1 │ │ │ TABLE SCAN keyword WHERE keyword = 'computer-animation' - 4523930 │ │ PROJECT keyword_id, movie_id - 4523930 │ │ PROJECT movie_id, keyword_id - 4523930 │ │ TABLE SCAN movie_keyword - 3 │ PROJECT id, title - 3 │ FILTER (1 AND production_year >= 2000_UInt16 AND production_year <= 2010_UInt16 AND title = 'Shrek 2'_String) AS a76 - 3 │ TABLE SCAN title WHERE (production_year >= 2000) AND (production_year <= 2010) AND (title = 'Shrek 2') - ∞ PROJECT movie_id_left, movie_id_left_2, movie_id_left_3, movie_id_right AS movie_id_left_4, name, name - ∞ PROJECT movie_id_left_2, movie_id_left, name, movie_id_left_3, movie_id_right, name - ∞ INNER JOIN HASH ON tuple(PROJECTION_3785.person_id,PROJECTION_3785.person_id,PROJECTION_3785.person_id) = tuple(PROJECTION_3770.id,PROJECTION_3770.id,PROJECTION_3770.person_id) - ∞ │└PROJECT id, person_id AS person_id_right, name AS name_right - ∞ │ PROJECT name, id, person_id - ∞ │ INNER JOIN HASH ON PROJECTION_3776.info_type_id = PROJECTION_3773.id - 1 │ │└PROJECT id AS id_right - 1 │ │ FILTER (1 AND info = 'trivia'_String) AS a71 - 1 │ │ TABLE SCAN info_type WHERE info = 'trivia' - ∞ │ PROJECT info_type_id, name, id AS id_left, person_id - ∞ │ PROJECT name, id, person_id, info_type_id - ∞ │ INNER JOIN HASH ON PROJECTION_3782.id = PROJECTION_3779.person_id - 2963664 │ │└PROJECT person_id, info_type_id - 2963664 │ │ PROJECT person_id, info_type_id - 2963664 │ │ TABLE SCAN person_info - ∞ │ PROJECT id, name - ∞ │ FILTER (1 AND LIKE (name,'%An%'_String) AND gender = 'f'_String) AS a63 - 50011 │ TABLE SCAN name WHERE (gender = 'f') AND name LIKE '%An%' - ∞ PROJECT person_id AS person_id_left, person_id AS person_id_left_2, movie_id, movie_id, name AS name_left, movie_id, movie_id - ∞ PROJECT person_id, person_id, movie_id, movie_id, name, movie_id, movie_id - ∞ INNER JOIN HASH ON PROJECTION_3791.role_id = PROJECTION_3788.id - 1 │└PROJECT id - 1 │ FILTER (1 AND role = 'actress'_String) AS a57 - 1 │ TABLE SCAN role_type WHERE role = 'actress' - ∞ PROJECT role_id, person_id, person_id, movie_id, movie_id, name, movie_id, movie_id - ∞ PROJECT person_id, person_id, movie_id, role_id, movie_id, name, movie_id, movie_id - ∞ INNER JOIN HASH ON PROJECTION_3797.info_type_id = PROJECTION_3794.id - 1 │└PROJECT id - 1 │ FILTER (1 AND info = 'release dates'_String) AS a53 - 1 │ TABLE SCAN info_type WHERE info = 'release dates' - ∞ PROJECT info_type_id, person_id, person_id, movie_id, role_id, movie_id, name, movie_id, movie_id - ∞ PROJECT person_id, person_id, movie_id, role_id, movie_id, name, movie_id, movie_id, info_type_id - ∞ INNER JOIN HASH ON tuple(PROJECTION_3803.movie_id,PROJECTION_3803.movie_id,PROJECTION_3803.movie_id) = tuple(PROJECTION_3800.movie_id,PROJECTION_3800.movie_id,PROJECTION_3800.movie_id) - ∞ │└PROJECT movie_id AS movie_id_right, info_type_id - ∞ │ FILTER (1 AND OR ( LIKE (info,'Japan:%200%'_String), LIKE (info,'USA:%200%'_String))) AS a45 - 451104 │ TABLE SCAN movie_info WHERE info LIKE 'Japan:%200%' OR info LIKE 'USA:%200%' - ∞ PROJECT movie_id AS movie_id_left, movie_id AS movie_id_left_2, movie_id AS movie_id_left_3, person_id, person_id, role_id, name - ∞ PROJECT person_id, person_id, movie_id, role_id, movie_id, name, movie_id - ∞ INNER JOIN HASH ON tuple(PROJECTION_3821.movie_id,PROJECTION_3821.movie_id) = tuple(PROJECTION_3806.movie_id,PROJECTION_3806.movie_id) - ∞ │└PROJECT movie_id AS movie_id_right, person_id, person_id, role_id, name - ∞ │ PROJECT person_id, person_id, movie_id, role_id, name - ∞ │ INNER JOIN HASH ON PROJECTION_3818.person_id = PROJECTION_3809.person_id - ∞ │ │└PROJECT person_id AS person_id_right, movie_id, role_id, name - ∞ │ │ PROJECT person_id, movie_id, role_id, name - ∞ │ │ INNER JOIN HASH ON PROJECTION_3815.person_role_id = PROJECTION_3812.id - 1 │ │ │└PROJECT id, name - 1 │ │ │ FILTER (1 AND name = 'Queen'_String) AS a41 - 1 │ │ │ TABLE SCAN char_name WHERE name = 'Queen' - ∞ │ │ PROJECT person_role_id, person_id, movie_id, role_id - ∞ │ │ FILTER (in(note,__set_String_16465705877069739944_5412506392037353102) AND 1) AS a37 - 36244344 │ │ TABLE SCAN cast_info WHERE TRUE - 901343 │ PROJECT person_id AS person_id_left - 901343 │ PROJECT person_id - 901343 │ TABLE SCAN aka_name - 0 PROJECT movie_id AS movie_id_left, movie_id AS movie_id_left_2 - 0 PROJECT movie_id, movie_id - 0 INNER JOIN HASH ON PROJECTION_3845.id = PROJECTION_3824.company_id - 166506 │└PROJECT company_id, movie_id, movie_id - 166506 │ PROJECT movie_id, movie_id, company_id - 166506 │ INNER JOIN HASH ON PROJECTION_3842.movie_id = PROJECTION_3827.movie_id - 17879 │ │└PROJECT movie_id AS movie_id_right - 17879 │ │ PROJECT movie_id - 17879 │ │ INNER JOIN HASH ON PROJECTION_3833.status_id = PROJECTION_3830.id - 1 │ │ │└PROJECT id - 1 │ │ │ FILTER (1 AND kind = 'complete+verified'_String) AS a31 - 1 │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'complete+verified' - 85941 │ │ PROJECT status_id, movie_id - 85941 │ │ PROJECT movie_id, status_id - 85941 │ │ INNER JOIN HASH ON PROJECTION_3839.subject_id = PROJECTION_3836.id - 1 │ │ │└PROJECT id - 1 │ │ │ FILTER (1 AND kind = 'cast'_String) AS a27 - 1 │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'cast' - 135086 │ │ PROJECT subject_id, movie_id, status_id - 135086 │ │ PROJECT movie_id, subject_id, status_id - 135086 │ │ TABLE SCAN complete_cast - 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 a20 - 0 TABLE SCAN company_name WHERE country_code = 'us'
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1), MIN(#2) 0 1620 PROJECT name, name, title 0 1620 INNER JOIN HASH ON id = role_id 0 1620 │└INNER JOIN HASH ON id = info_type_id 0 4890 │ │└INNER JOIN HASH ON person_id = id 0 30 │ │ │└INNER JOIN HASH ON id = person_id 0 30 │ │ │ │└INNER JOIN HASH ON person_id = person_id 0 10 │ │ │ │ │└INNER JOIN HASH ON id = person_role_id 0 380 │ │ │ │ │ │└INNER JOIN HASH ON movie_id = id 0 10 │ │ │ │ │ │ │└INNER JOIN HASH ON id = keyword_id 0 1080 │ │ │ │ │ │ │ │└INNER JOIN HASH ON movie_id = id 0 10 │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON id = info_type_id 0 10 │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON movie_id = id 0 5 │ │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON id = company_id 0 22 │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON movie_id = id 0 1 │ │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON id = status_id 0 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON id = subject_id 0 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON id = id 3 3 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │└FILTER id BETWEEN 285 AND 2525745 3 3 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SCAN title WHERE title = 'Shrek 2' AND production_year >= 2000 AND production_year <= 2010 135086 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SCAN complete_cast WHERE movie_id <= 2525745 1 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │ FILTER id <= 2 1 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'cast' 1 1 │ │ │ │ │ │ │ │ │ │ │ │ │ FILTER id >= 3 1 1 │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'complete+verified' 2609129 22 │ │ │ │ │ │ │ │ │ │ │ │ TABLE SCAN movie_companies WHERE movie_id >= 285 1644 57 │ │ │ │ │ │ │ │ │ │ │ TABLE SCAN company_name WHERE country_code = 'us' 2967144 2 │ │ │ │ │ │ │ │ │ │ FILTER movie_id BETWEEN 285 AND 2525745 2967144 2 │ │ │ │ │ │ │ │ │ │ TABLE SCAN movie_info WHERE (info IS NOT NULL) AND ((info LIKE 'Japan:%200%') OR (info LIKE 'USA:%200%')) 2 1 │ │ │ │ │ │ │ │ │ FILTER id <= 110 2 1 │ │ │ │ │ │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates' 4523930 108 │ │ │ │ │ │ │ │ TABLE SCAN movie_keyword WHERE movie_id >= 285 AND movie_id <= 2525745 2 1 │ │ │ │ │ │ │ TABLE SCAN keyword WHERE keyword = 'computer-animation' 7248868 38 │ │ │ │ │ │ FILTER (person_id >= 4) AND (movie_id BETWEEN 285 AND 2525745) 7248868 38 │ │ │ │ │ │ FILTER (note = '(voice)') OR (note = '(voice) (uncredited)') OR (note = '(voice: English version)') 36244344 228 │ │ │ │ │ │ TABLE SCAN cast_info WHERE note IN('(voice)','(voice) (uncredited)','(voice: English version)') 1 1 │ │ │ │ │ TABLE SCAN char_name WHERE name = 'Queen' 901343 3 │ │ │ │ TABLE SCAN aka_name WHERE person_id <= 4061926 2083746 1 │ │ │ FILTER id BETWEEN 4 AND 4061926 2083746 1 │ │ │ TABLE SCAN "name" WHERE gender = 'f' AND contains(name,'An') 2963664 163 │ │ TABLE SCAN person_info WHERE person_id <= 4061926 2 1 │ FILTER id BETWEEN 15 AND 39 2 1 │ TABLE SCAN info_type WHERE info = 'trivia' 1 1 FILTER id <= 11 1 1 TABLE SCAN role_type WHERE role = 'actress'
	Estimate Actual Operator 1 1 PROJECT voiced_char, voicing_actress, voiced_animation 1 1 AGGREGATE MIN(name), MIN(name), MIN(title) 3849 10 DISTRIBUTE GATHER 3849 10 AGGREGATE MIN(name), MIN(name), MIN(title) 3849 1620 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id 3849 1620 │└DISTRIBUTE GATHER 3849 1620 │ 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' 14113 1620 │ INNER JOIN HASH ON id = info_type_id 23 1 │ │└DISTRIBUTE GATHER 23 1 │ │ FILTER info = 'trivia' 113 113 │ │ DISTRIBUTE ROUND ROBIN 113 113 │ │ TABLE SCAN info_type WHERE info = 'trivia' 15341 4890 │ INNER JOIN HASH ON id = person_id AND person_id = person_id 15341 30 │ │└DISTRIBUTE GATHER 15341 30 │ │ INNER JOIN HASH ON person_id = id AND person_id = id 15341 30 │ │ │└DISTRIBUTE GATHER 15341 30 │ │ │ INNER JOIN HASH ON keyword_id = id 15341 11016 │ │ │ │└DISTRIBUTE GATHER 15341 11016 │ │ │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id 8566 102 │ │ │ │ │└DISTRIBUTE GATHER 8566 102 │ │ │ │ │ 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' 40970 102 │ │ │ │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id 34885 142 │ │ │ │ │ │└DISTRIBUTE GATHER 34885 142 │ │ │ │ │ │ INNER JOIN HASH ON company_id = id 34885 469 │ │ │ │ │ │ │└DISTRIBUTE GATHER 34885 469 │ │ │ │ │ │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id 33771 17 │ │ │ │ │ │ │ │└DISTRIBUTE GATHER 33771 17 │ │ │ │ │ │ │ │ INNER JOIN HASH ON person_role_id = id 33771 2737 │ │ │ │ │ │ │ │ │└DISTRIBUTE GATHER 33771 2737 │ │ │ │ │ │ │ │ │ INNER JOIN HASH ON id = status_id 1 1 │ │ │ │ │ │ │ │ │ │└DISTRIBUTE GATHER 1 1 │ │ │ │ │ │ │ │ │ │ FILTER kind = 'complete+verified' 4 4 │ │ │ │ │ │ │ │ │ │ DISTRIBUTE ROUND ROBIN 4 4 │ │ │ │ │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'complete+verified' 67543 20407 │ │ │ │ │ │ │ │ │ INNER JOIN HASH ON id = subject_id 1 1 │ │ │ │ │ │ │ │ │ │└DISTRIBUTE GATHER 1 1 │ │ │ │ │ │ │ │ │ │ FILTER kind = 'cast' 4 4 │ │ │ │ │ │ │ │ │ │ DISTRIBUTE ROUND ROBIN 4 4 │ │ │ │ │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'cast' 135086 28513 │ │ │ │ │ │ │ │ │ PROJECT person_id, person_id, movie_id, person_role_id, role_id, movie_id, subject_id, status_id 135086 28513 │ │ │ │ │ │ │ │ │ INNER JOIN HASH ON movie_id = movie_id 135086 122880 │ │ │ │ │ │ │ │ │ │└DISTRIBUTE HASH ON movie_id 135086 122880 │ │ │ │ │ │ │ │ │ │ TABLE SCAN complete_cast WHERE (((subject_id >= 1) AND (subject_id <= 1)) AND subject_id IN 1) AND (((status_id >= 4) AND (status_id <= 4)) AND status_id IN 4) 1608526 507695 │ │ │ │ │ │ │ │ │ DISTRIBUTE HASH ON movie_id 1608526 507695 │ │ │ │ │ │ │ │ │ INNER JOIN HASH ON person_id = person_id 901343 901343 │ │ │ │ │ │ │ │ │ │└DISTRIBUTE HASH ON person_id 901343 901343 │ │ │ │ │ │ │ │ │ │ TABLE SCAN aka_name 7248869 268042 │ │ │ │ │ │ │ │ │ DISTRIBUTE HASH ON person_id 7248869 268042 │ │ │ │ │ │ │ │ │ FILTER ((note = '(voice)') OR (note = '(voice) (uncredited)')) OR (note = '(voice: English version)') 36244344 7656546 │ │ │ │ │ │ │ │ │ TABLE SCAN cast_info WHERE (((((note = '(voice)') OR (note = '(voice) (uncredited)')) OR (note = '(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)) A... 628068 1 │ │ │ │ │ │ │ │ FILTER name = 'Queen' 3140339 3140339 │ │ │ │ │ │ │ │ TABLE SCAN char_name WHERE (name = 'Queen') AND (((id >= 21) AND (id <= 3129993)) AND TRUE) 2609129 2240489 │ │ │ │ │ │ │ TABLE SCAN movie_companies WHERE (((movie_id >= 1645050) AND (movie_id <= 2296721)) AND ((movie_id >= 1645050) AND (movie_id <= 2296721))) AND struct(movie_id,movie_id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > ) 47000 44844 │ │ │ │ │ │ FILTER country_code = 'us' 234997 122880 │ │ │ │ │ │ TABLE SCAN company_name WHERE (country_code = 'us') AND (((id >= 19) AND (id <= 95261)) AND id IN(160,160,160,521,521,521,521,521,521,9269,9269,9269,11669,11669,11669,664,664,664,12199,12199,12199,18709,18709,18709,12523,12523,12523,12524,12524,12524,12823,12823,12823,11378,11378,11378,12525,12525,12525,13836,13836,13836,12526,12526,12526,12249,12249,12249,2476,2476,2476,2476,2476,2476,530,530,530,143,143,143,143,143,143,4617,4617,4617,4617,4617,461... 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 (((((movie_id >= 1645050) AND (movie_id <= 2296721)) AND ((movie_id >= 1645050) AND (movie_id <= 2296721))) AND ((movie_id >= 1645050) AND (movie_id <= 2296721))) AND struct(movie_id,movie_id,movie_id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , <... 4523930 2305780 │ │ │ │ TABLE SCAN movie_keyword WHERE (((((movie_id >= 2285018) AND (movie_id <= 2296721)) AND ((movie_id >= 2285018) AND (movie_id <= 2296721))) AND ((movie_id >= 2285018) AND (movie_id <= 2296721))) AND ((movie_id >= 2285018) AND (movie_id <= 2296721))) AND TRUE 26834 1 │ │ │ FILTER keyword = 'computer-animation' 134170 134170 │ │ │ DISTRIBUTE ROUND ROBIN 134170 134170 │ │ │ TABLE SCAN keyword WHERE (keyword = 'computer-animation') AND (((id >= 1) AND (id <= 121817)) AND TRUE) 833499 11978 │ │ FILTER (gender = 'f') AND name LIKE '%An%' 4167491 122880 │ │ TABLE SCAN name WHERE ((gender = 'f') AND name LIKE '%An%') AND ((((id >= 1763943) AND (id <= 1763943)) AND ((id >= 1763943) AND (id <= 1763943))) AND struct(id,id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < e... 2963664 2963664 │ TABLE SCAN person_info WHERE ((((person_id >= 1763943) AND (person_id <= 1763943)) AND ((person_id >= 1763943) AND (person_id <= 1763943))) AND struct(person_id,person_id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , ... 505663 2 FILTER ((title = 'Shrek 2') AND (production_year >= 2000)) AND (production_year <= 2010) 2528312 245760 TABLE SCAN title WHERE (((title = 'Shrek 2') AND (production_year >= 2000)) AND (production_year <= 2010)) AND (((((((id >= 2285018) AND (id <= 2285018)) AND ((id >= 2285018) AND (id <= 2285018))) AND ((id >= 2285018) AND (id <= 2285018))) AND ((id >= 2285018) AND (id <= 2285018))) AND ((id >= 2285018) AND (id <= 2285018))) AND TRUE)
	Estimate Actual Operator 1 1 AGGREGATE MIN(chn.name), MIN(n.name), MIN(t.title) 1 2 DISTRIBUTE GATHER 1 2 AGGREGATE MIN(chn.name), MIN(n.name), MIN(t.title) 2310 1620 INNER JOIN HASH ON mk.movie_id = t.id 2310 3 │└DISTRIBUTE GATHER 901000 3 │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.title = 'Shrek 2') AND (t.production_year >= 2000L) AND (t.production_year <= 2010L) 2310 1620 INNER JOIN HASH ON ci.role_id = rt.id 2310 1 │└DISTRIBUTE GATHER 36200000 1 │ TABLE SCAN role_type WHERE rt.role = 'actress' 435 1620 INNER JOIN HASH ON n.id = pi.person_id 435 30 │└DISTRIBUTE GATHER 435 30 │ INNER JOIN HASH ON ci.person_id = n.id 435 30 │ │└DISTRIBUTE GATHER 435 30 │ │ INNER JOIN HASH ON mc.movie_id = mk.movie_id 435 414 │ │ │└DISTRIBUTE GATHER 27 414 │ │ │ INNER JOIN HASH ON mk.keyword_id = k.id 27 1 │ │ │ │└DISTRIBUTE GATHER 2610000 1 │ │ │ │ TABLE SCAN keyword WHERE k.keyword = 'computer-animation' 4 4503451 │ │ │ TABLE SCAN movie_keyword 69 102 │ │ INNER JOIN HASH ON mc.movie_id = mi.movie_id 69 142 │ │ │└DISTRIBUTE GATHER 27 142 │ │ │ INNER JOIN HASH ON ci.movie_id = mc.movie_id 27 17 │ │ │ │└DISTRIBUTE GATHER 11 17 │ │ │ │ INNER JOIN HASH ON ci.person_role_id = chn.id 11 1 │ │ │ │ │└DISTRIBUTE GATHER 113 1 │ │ │ │ │ TABLE SCAN char_name WHERE chn.name = 'Queen' 11 14509 │ │ │ │ INNER JOIN HASH ON cc.status_id = cct2.id 11 1 │ │ │ │ │└DISTRIBUTE GATHER 134000 1 │ │ │ │ │ TABLE SCAN comp_cast_type WHERE cct2.kind = 'complete+verified' 12100 86648 │ │ │ │ INNER JOIN HASH ON cc.subject_id = cct1.id 12100 1 │ │ │ │ │└DISTRIBUTE GATHER 2960000 1 │ │ │ │ │ TABLE SCAN comp_cast_type WHERE cct1.kind = 'cast' 71 146275 │ │ │ │ INNER JOIN HASH ON ci.movie_id = cc.movie_id 71 1696720 │ │ │ │ │└DISTRIBUTE GATHER 135000 1696720 │ │ │ │ │ INNER JOIN HASH ON an.person_id = ci.person_id 135000 770702 │ │ │ │ │ │└DISTRIBUTE GATHER 2530000 770702 │ │ │ │ │ │ TABLE SCAN cast_info WHERE (ci.note IN('(voice)','(voice) (uncredited)','(voice: English version)')) AND (ci.person_role_id IS NOT NULL) 113 897444 │ │ │ │ │ TABLE SCAN aka_name 4170000 131066 │ │ │ │ TABLE SCAN complete_cast WHERE cc.movie_id IS NOT NULL 18 926065 │ │ │ INNER JOIN HASH ON mc.company_id = cn.id 18 84843 │ │ │ │└DISTRIBUTE GATHER 4520000 84843 │ │ │ │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND (cn.country_code = 'us') 235000 2183148 │ │ │ TABLE SCAN movie_companies 27 52372 │ │ INNER JOIN HASH ON mi.info_type_id = it.id 27 1 │ │ │└DISTRIBUTE GATHER 14800000 1 │ │ │ TABLE SCAN info_type WHERE it.info = 'release dates' 4 52372 │ │ TABLE SCAN movie_info WHERE mi.info LIKE 'Japan:%200%' OR mi.info LIKE 'USA:%200%' 12 39153 │ TABLE SCAN name WHERE (n.gender IS NOT NULL) AND (n.gender = 'f') AND contains(n.name,'An') 435 346974 INNER JOIN HASH ON pi.info_type_id = it3.id 435 1 │└DISTRIBUTE GATHER 135000 1 │ TABLE SCAN info_type WHERE it3.info = 'trivia' 3140000 1656847 TABLE SCAN person_info
	Estimate Actual Operator 1 1 AGGREGATE MIN(name as name) AS Expr1034, MIN(name as name) AS Expr1035, MIN(title as title) AS Expr1036 1 1620 INNER JOIN HASH ON pi.info_type_id = it3.id 1 1 │└TABLE SCAN info_type AS it3 WHERE info as info = 'trivia' 80 1620 INNER JOIN LOOP ON Bmk1028 = Bmk1028 1 1620 │└TABLE SEEK person_info AS pi WHERE BLOOM(info_type_id as info_type_id) 804 4890 PROJECT BmkToPage Bmk1028 AS Expr1131 804 4890 INNER JOIN LOOP ON n.id = pi.person_id 46 4890 │└TABLE SEEK person_info AS pi 17 30 FILTER country_code as country_code = 'us' 48 132 INNER JOIN LOOP ON Bmk1012 = Bmk1012 1 132 │└TABLE SEEK company_name AS cn 48 132 INNER JOIN LOOP ON mc.company_id = cn.id 1 132 │└TABLE SEEK company_name AS cn 48 132 INNER JOIN LOOP ON Bmk1020 = Bmk1020 1 132 │└TABLE SEEK movie_companies AS mc 48 132 PROJECT BmkToPage Bmk1020 AS Expr1127 48 132 INNER JOIN LOOP ON t.id = mc.movie_id 9 132 │└TABLE SEEK movie_companies AS mc 4 6 INNER JOIN LOOP ON n.id = an.person_id 4 6 │└TABLE SEEK aka_name AS an 1 2 FILTER name as name LIKE '%An%' AND gender as gender = 'f' 1 2 INNER JOIN LOOP ON Bmk1026 = Bmk1026 1 2 │└TABLE SEEK name AS n 1 2 PROJECT BmkToPage Bmk1026 AS Expr1126 1 2 INNER JOIN LOOP ON ci.person_id = n.id 1 2 │└TABLE SEEK name AS n 1 2 FILTER name as name = 'Queen' 1 22 INNER JOIN LOOP ON Bmk1008 = Bmk1008 1 22 │└TABLE SEEK char_name AS chn 1 22 PROJECT BmkToPage Bmk1008 AS Expr1125 1 22 INNER JOIN LOOP ON ci.person_role_id = chn.id 1 22 │└TABLE SEEK char_name AS chn 1 22 FILTER role as role = 'actress' 1 76 INNER JOIN LOOP ON Bmk1030 = Bmk1030 1 76 │└TABLE SEEK role_type AS rt 1 76 INNER JOIN LOOP ON ci.role_id = rt.id 1 76 │└TABLE SEEK role_type AS rt 1 76 FILTER note as note = '(voice)' OR note as note = '(voice) (uncredited)' OR note as note = '(voice: English version)' 30 458 INNER JOIN LOOP ON Bmk1010 = Bmk1010 1 458 │└TABLE SEEK cast_info AS ci 30 458 PROJECT BmkToPage Bmk1010 AS Expr1123 30 458 INNER JOIN LOOP ON t.id = ci.movie_id 30 458 │└TABLE SEEK cast_info AS ci 1 2 FILTER info as info = 'release dates' 1 2 INNER JOIN LOOP ON Bmk1014 = Bmk1014 1 2 │└TABLE SEEK info_type AS it 1 2 INNER JOIN LOOP ON mi.info_type_id = it.id 1 2 │└TABLE SEEK info_type AS it 1 2 INNER JOIN LOOP ON t.id = mi.movie_id 1 2 │└TABLE SEEK movie_info AS mi WHERE info as info LIKE 'Japan:%200%' OR info as info LIKE 'USA:%200%' 1 1 FILTER kind as kind = 'cast' 1 1 INNER JOIN LOOP ON Bmk1004 = Bmk1004 1 1 │└TABLE SEEK comp_cast_type AS cct1 1 1 INNER JOIN LOOP ON cc.subject_id = cct1.id 1 1 │└TABLE SEEK comp_cast_type AS cct1 1 1 FILTER kind as kind = 'complete+verified' 1 1 INNER JOIN LOOP ON Bmk1006 = Bmk1006 1 1 │└TABLE SEEK comp_cast_type AS cct2 1 1 INNER JOIN LOOP ON cc.status_id = cct2.id 1 1 │└TABLE SEEK comp_cast_type AS cct2 1 1 INNER JOIN LOOP ON Bmk1002 = Bmk1002 1 1 │└TABLE SEEK complete_cast AS cc 1 1 INNER JOIN LOOP ON t.id = cc.movie_id 1 1 │└TABLE SEEK complete_cast AS cc 1 1 FILTER title as title = 'Shrek 2' 1 249 INNER JOIN LOOP ON Bmk1032 = Bmk1032 0 249 │└TABLE SEEK title AS t WHERE production_year as production_year >= 2000 AND production_year as production_year <= 2010 90 414 PROJECT BmkToPage Bmk1032 AS Expr1121 90 414 INNER JOIN LOOP ON mk.movie_id = t.id 1 414 │└TABLE SEEK title AS t 90 414 INNER JOIN LOOP ON Bmk1024 = Bmk1024 1 414 │└TABLE SEEK movie_keyword AS mk 90 414 INNER JOIN LOOP ON k.id = mk.keyword_id 90 414 │└TABLE SEEK movie_keyword AS mk 1 1 TABLE SCAN keyword AS k WHERE keyword as keyword = 'computer-animation'
	Estimate Actual Operator 1 ∞ PROJECT min AS voiced_char, min_98 AS voicing_actress, min_99 AS voiced_animation 1 1 AGGREGATE MIN(min_100) AS min, MIN(min_101) AS min_98, MIN(min_102) AS min_99 - 16 DISTRIBUTE GATHER - 16 AGGREGATE MIN(name_14) AS min_100, MIN(name_68) AS min_101, MIN(title) AS min_102 - 1620 INNER JOIN HASH ON movie_id_24 = id_90 159036 3 │└DISTRIBUTE HASH ON id_90 159036 3 │ PROJECT id AS id_90, title 159036 3 │ FILTER (production_year BETWEEN 2000 AND 2010) AND (title = 'Shrek 2') 159036 3 │ TABLE SCAN title - 1620 INNER JOIN HASH ON role_id = id_86 12 1 │└DISTRIBUTE GATHER 12 1 │ PROJECT id AS id_86 12 1 │ FILTER role = 'actress' 12 1 │ TABLE SCAN role_type - 1620 INNER JOIN HASH ON info_type_id_80 = id_40 113 1 │└DISTRIBUTE GATHER 113 1 │ PROJECT id AS id_40 113 1 │ FILTER info = 'trivia' 113 1 │ TABLE SCAN info_type - 1620 INNER JOIN HASH ON person_id_23 = person_id_79 2963664 620526 │└DISTRIBUTE HASH ON person_id_79 2963664 620526 │ PROJECT person_id AS person_id_79, info_type_id AS info_type_id_80 2963664 620526 │ TABLE SCAN person_info - 30 INNER JOIN HASH ON person_id_23 = id_67 3750742 3136 │└DISTRIBUTE HASH ON id_67 3750742 3136 │ PROJECT id AS id_67, name AS name_68 3750742 3136 │ FILTER (gender = 'f') AND (name LIKE '%An%') 3750742 3136 │ TABLE SCAN name - 30 INNER JOIN HASH ON keyword_id = id_45 134170 1 │└DISTRIBUTE GATHER 134170 1 │ PROJECT id AS id_45 134170 1 │ FILTER keyword = 'computer-animation' 134170 1 │ TABLE SCAN keyword - 30 INNER JOIN HASH ON movie_id_24 = movie_id_63 4523930 1 │└DISTRIBUTE HASH ON movie_id_63 4523930 1 │ PROJECT movie_id AS movie_id_63, keyword_id 4523930 1 │ TABLE SCAN movie_keyword - 30 INNER JOIN HASH ON info_type_id = id_36 113 1 │└DISTRIBUTE GATHER 113 1 │ PROJECT id AS id_36 113 1 │ FILTER info = 'release dates' 113 1 │ TABLE SCAN info_type - 30 INNER JOIN HASH ON movie_id_24 = movie_id_56 13352148 2 │└DISTRIBUTE HASH ON movie_id_56 13352148 2 │ PROJECT movie_id AS movie_id_56, info_type_id 13352148 2 │ FILTER (((info >= 'Japan:') AND (info < 'Japan;')) OR ((info >= 'USA:') AND (info < 'USA;'))) AND ((info LIKE 'Japan:%200%') OR (info LIKE 'USA:%200%')) 13352148 2 │ TABLE SCAN movie_info - 15 INNER JOIN HASH ON company_id = id_28 234997 84843 │└DISTRIBUTE GATHER 234997 84843 │ PROJECT id AS id_28 234997 84843 │ FILTER country_code = 'us' 234997 84843 │ TABLE SCAN company_name - 15 INNER JOIN HASH ON movie_id_24 = movie_id_50 2609129 5 │└DISTRIBUTE HASH ON movie_id_50 2609129 5 │ PROJECT movie_id AS movie_id_50, company_id 2609129 5 │ TABLE SCAN movie_companies - 3 INNER JOIN HASH ON person_role_id = id_13 3140339 1 │└DISTRIBUTE HASH ON id_13 3140339 1 │ PROJECT id AS id_13, name AS name_14 3140339 1 │ FILTER name = 'Queen' 3140339 1 │ TABLE SCAN char_name - 3 INNER JOIN HASH ON status_id = id_8 4 1 │└DISTRIBUTE GATHER 4 1 │ PROJECT id AS id_8 4 1 │ FILTER kind = 'complete+verified' 4 1 │ TABLE SCAN comp_cast_type - 3 INNER JOIN HASH ON subject_id = id_4 4 1 │└DISTRIBUTE GATHER 4 1 │ PROJECT id AS id_4 4 1 │ FILTER kind = 'cast' 4 1 │ TABLE SCAN comp_cast_type - 3 INNER JOIN HASH ON movie_id_24 = movie_id 135086 1 │└DISTRIBUTE GATHER 135086 1 │ TABLE SCAN complete_cast - 3 INNER JOIN HASH ON person_id_23 = person_id 901343 3464 │└DISTRIBUTE GATHER 901343 3464 │ TABLE SCAN aka_name 32619910 1 PROJECT person_id AS person_id_23, movie_id AS movie_id_24, person_role_id, role_id 32619910 1 FILTER note IN('(voice)','(voice) (uncredited)','(voice: English version)') 32619910 1 TABLE SCAN cast_info
	Estimate Actual Operator 1 1 AGGREGATE MIN(name), MIN(name), MIN(title) 1 1620 INNER JOIN LOOP ON id = person_role_id 1 1620 │└INNER JOIN LOOP ON person_id = person_id AND person_id = id AND (person_id = id) 1 540 │ │└INNER JOIN LOOP ON id = info_type_id 1 540 │ │ │└INNER JOIN LOOP ON id = info_type_id 1 1630 │ │ │ │└INNER JOIN LOOP ON person_id = person_id AND id = person_id AND (id = person_id) 1 10 │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 5 │ │ │ │ │ │└INNER JOIN LOOP ON id = role_id 1 5 │ │ │ │ │ │ │└INNER JOIN LOOP ON id = status_id 1 5 │ │ │ │ │ │ │ │└INNER JOIN LOOP ON id = subject_id 1 5 │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 5 │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON id = company_id 1 22 │ │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 1 │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON id = person_id 1 38 │ │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON id = movie_id 34 414 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON keyword_id = id 1 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │└TABLE SEEK keyword AS k 305 414 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SEEK movie_keyword AS mk 414 414 │ │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SEEK title AS t WHERE (t.production_year >= 2000) AND (t.production_year <= 2010) AND (t.title = 'Shrek 2') 1 38 │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SEEK cast_info AS ci WHERE ci.note IN('(voice)','(voice) (uncredited)','(voice: English version)') 38 38 │ │ │ │ │ │ │ │ │ │ │ │ TABLE SEEK name AS n WHERE (n.name LIKE '%An%') AND (n.gender = 'f') 5 22 │ │ │ │ │ │ │ │ │ │ │ TABLE SEEK movie_companies AS mc 22 22 │ │ │ │ │ │ │ │ │ │ TABLE SEEK company_name AS cn WHERE cn.country_code = 'us' 10 5 │ │ │ │ │ │ │ │ │ TABLE SEEK complete_cast AS cc 5 5 │ │ │ │ │ │ │ │ TABLE SEEK comp_cast_type AS cct1 WHERE cct1.kind = 'cast' 5 5 │ │ │ │ │ │ │ TABLE SEEK comp_cast_type AS cct2 WHERE cct2.kind = 'complete+verified' 5 5 │ │ │ │ │ │ TABLE SEEK role_type AS rt WHERE rt.role = 'actress' 10 10 │ │ │ │ │ TABLE SEEK movie_info AS mi WHERE (mi.info LIKE 'Japan:%200%') OR (mi.info LIKE 'USA:%200%') 250 1630 │ │ │ │ TABLE SEEK person_info AS pi 1630 1630 │ │ │ TABLE SEEK info_type AS it3 WHERE it3.info = 'trivia' 540 540 │ │ TABLE SEEK info_type AS it WHERE it.info = 'release dates' 1080 1620 │ TABLE SEEK aka_name AS an 1620 1620 TABLE SEEK char_name AS chn WHERE chn.name = 'Queen'