Planner — IMDB — JOB-23C

SELECT MIN(kt.kind) AS movie_kind,
       MIN(t.title) AS complete_us_internet_movie
FROM job.complete_cast AS cc,
     job.comp_cast_type AS cct1,
     job.company_name AS cn,
     job.company_type AS ct,
     job.info_type AS it1,
     job.keyword AS k,
     job.kind_type AS kt,
     job.movie_companies AS mc,
     job.movie_info AS mi,
     job.movie_keyword AS mk,
     job.title AS t
WHERE cct1.kind = 'complete+verified'
  AND cn.country_code = '[us]'
  AND it1.info = 'release dates'
  AND kt.kind IN ('movie',
                  'tv movie',
                  'video movie',
                  'video game')
  AND mi.note LIKE '%internet%'
  AND mi.info IS NOT NULL
  AND (mi.info LIKE 'USA:% 199%'
       OR mi.info LIKE 'USA:% 200%')
  AND t.production_year > 1990
  AND kt.id = t.kind_id
  AND t.id = mi.movie_id
  AND t.id = mk.movie_id
  AND t.id = mc.movie_id
  AND t.id = cc.movie_id
  AND mk.movie_id = mi.movie_id
  AND mk.movie_id = mc.movie_id
  AND mk.movie_id = cc.movie_id
  AND mi.movie_id = mc.movie_id
  AND mi.movie_id = cc.movie_id
  AND mc.movie_id = cc.movie_id
  AND k.id = mk.keyword_id
  AND it1.id = mi.info_type_id
  AND cn.id = mc.company_id
  AND ct.id = mc.company_type_id
  AND cct1.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 4,664,690 4.7M Rank		Estimation Error Est Err 4,662,931 4.7M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 3,084 3.1K Rank	Estimation Error Est Err 628 628 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 9,153,143 9.2M 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 5,616,604 5.6M Rank		Estimation Error Est Err 5,264,936 5.3M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 356,512 357K Rank	Estimation Error Est Err 629 629 Rank	Estimation Error Est Err 354,129 354K Rank
Estimation Error Est Err 10,668,397 11M Rank		Estimation Error Est Err 7,100,214 7.1M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 570,660 571K Rank	Estimation Error Est Err 638 638 Rank	Estimation Error Est Err 485,383 485K Rank
Estimation Error Est Err 2,838,278 2.8M Rank		Estimation Error Est Err 3,057,930 3.1M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 2,688,943 2.7M Rank	Estimation Error Est Err 628 628 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 166,012 166K Rank	Estimation Error Est Err 30,920 31K Rank	Estimation Error Est Err 172,438 172K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 60,573 61K Rank	Estimation Error Est Err 628 628 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 2,738 2.7K Rank	Estimation Error Est Err 2,625 2.6K Rank	Estimation Error Est Err 4,370 4.4K Rank	Estimation Error Est Err 1,786 1.8K Rank	Estimation Error Est Err 2,625 2.6K Rank	Estimation Error Est Err 629 629 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 5,267,065 5.3M Rank		Estimation Error Est Err 2,545 2.5K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 5,267,695 5.3M Rank	Estimation Error Est Err 644 644 Rank	Estimation Error Est Err 5,267,077 5.3M Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min 610 628 INNER JOIN HASH ON id75 = keyword_id 636 628 │└INNER JOIN HASH ON id36 = movie_id70 341 7 │ │└INNER JOIN HASH ON id = company_type_id 4 4 │ │ │└TABLE SCAN company_type 305 7 │ │ INNER JOIN HASH ON id59 = company_id 831 7 │ │ │└INNER JOIN HASH ON movie_id52 = id36 263 6 │ │ │ │└INNER JOIN HASH ON id6 = info_type_id 1 1 │ │ │ │ │└TABLE SCAN info_type WHERE info = release dates 263 6 │ │ │ │ INNER JOIN HASH ON id11 = kind_id 4 4 │ │ │ │ │└TABLE SCAN kind_type WHERE kind12 IN(movie,tv movie,video game,video movie) 220 6 │ │ │ │ INNER JOIN HASH ON id36 = movie_id30 301 6 │ │ │ │ │└INNER JOIN HASH ON id16 = status_id 1 1 │ │ │ │ │ │└TABLE SCAN comp_cast_type WHERE kind = complete + verified 1205 6 │ │ │ │ │ INNER JOIN HASH ON movie_id = movie_id30 5154 1783 │ │ │ │ │ │└TABLE SCAN movie_info WHERE info) USA : AND note LIKE '%internet%' AND info24 LIKE '% 199%' OR info24 LIKE '% 200%' 135086 4786 │ │ │ │ │ TABLE SCAN complete_cast 1757966 3 │ │ │ │ TABLE SCAN title WHERE production_year >= 1991 2076277 4 │ │ │ TABLE SCAN movie_companies 90648 4 │ │ TABLE SCAN company_name WHERE country_code = us 4523930 4523930 │ TABLE SCAN movie_keyword 134170 134170 TABLE SCAN keyword
	Estimate Actual Operator - ∞ PROJECT a1 AS movie_kind, a2 AS complete_us_internet_movie - ∞ AGGREGATE MIN(kind) AS a1, MIN(title) AS a2 - ∞ PROJECT kind, title - ∞ PROJECT title, kind - ∞ INNER JOIN HASH ON tuple(PROJECTION_2717.movie_id,PROJECTION_2717.movie_id,PROJECTION_2717.movie_id,PROJECTION_2717.movie_id,PROJECTION_2717.movie_id,PROJECTION_2717.movie_id) = tuple(PROJECTION_2678.movie_id,PROJECTION_2678.movie_id,PROJECTION_2678.movie_id,PROJECTION_2678.movie_id,PROJECTION_2678.id,PROJECTION_2678.id) - ∞ │└PROJECT movie_id_right, movie_id AS movie_id_right_2, id, title, kind - ∞ │ PROJECT movie_id, movie_id, title, id, kind - ∞ │ INNER JOIN HASH ON PROJECTION_2684.kind_id = PROJECTION_2681.id - ∞ │ │└PROJECT id AS id_right, kind - ∞ │ │ FILTER (in(kind,__set_String_3875239924843678209_2671243455701509582) AND 1) AS a48 - 7 │ │ TABLE SCAN kind_type WHERE TRUE - 0 │ PROJECT kind_id, movie_id, movie_id, title, id AS id_left - 0 │ PROJECT movie_id, movie_id, title, id, kind_id - 0 │ INNER JOIN HASH ON tuple(PROJECTION_2690.movie_id,PROJECTION_2690.movie_id) = tuple(PROJECTION_2687.id,PROJECTION_2687.id) - 1749032 │ │└PROJECT id, title, kind_id - 1749032 │ │ FILTER (1 AND production_year > 1990_UInt16) AS a44 - 1749032 │ │ TABLE SCAN title WHERE production_year > 1990 - 0 │ PROJECT movie_id, movie_id - 0 │ PROJECT movie_id, movie_id - 0 │ INNER JOIN HASH ON PROJECTION_2696.company_id = PROJECTION_2693.id - 0 │ │└PROJECT id - 0 │ │ FILTER (1 AND country_code = 'us'_String) AS a40 - 0 │ │ TABLE SCAN company_name WHERE country_code = 'us' - 227682 │ PROJECT company_id, movie_id, movie_id - 227682 │ PROJECT movie_id, movie_id, company_id - 227682 │ INNER JOIN HASH ON PROJECTION_2702.company_type_id = PROJECTION_2699.id - 4 │ │└PROJECT id - 4 │ │ PROJECT id - 4 │ │ TABLE SCAN company_type - 227682 │ PROJECT company_type_id, movie_id, movie_id, company_id - 227682 │ PROJECT movie_id, movie_id, company_id, company_type_id - 227682 │ INNER JOIN HASH ON PROJECTION_2708.movie_id = PROJECTION_2705.movie_id - 2609129 │ │└PROJECT movie_id AS movie_id_right, company_id, company_type_id - 2609129 │ │ PROJECT movie_id, company_id, company_type_id - 2609129 │ │ TABLE SCAN movie_companies - 24592 │ PROJECT movie_id AS movie_id_left - 24592 │ PROJECT movie_id - 24592 │ INNER JOIN HASH ON PROJECTION_2714.status_id = PROJECTION_2711.id - 1 │ │└PROJECT id - 1 │ │ FILTER (1 AND kind = 'complete+verified'_String) AS a36 - 1 │ │ TABLE SCAN comp_cast_type WHERE kind = 'complete+verified' - 135086 │ PROJECT status_id, movie_id - 135086 │ PROJECT status_id, movie_id - 135086 │ TABLE SCAN complete_cast - ∞ PROJECT movie_id_left, movie_id AS movie_id_left_2 - ∞ PROJECT movie_id, movie_id - ∞ INNER JOIN HASH ON PROJECTION_2723.keyword_id = PROJECTION_2720.id - 134170 │└PROJECT id - 134170 │ PROJECT id - 134170 │ TABLE SCAN keyword - ∞ PROJECT keyword_id, movie_id, movie_id - ∞ PROJECT movie_id, movie_id, keyword_id - ∞ INNER JOIN HASH ON PROJECTION_2729.movie_id = PROJECTION_2726.movie_id - 4523930 │└PROJECT movie_id AS movie_id_right, keyword_id - 4523930 │ PROJECT movie_id, keyword_id - 4523930 │ TABLE SCAN movie_keyword - ∞ PROJECT movie_id AS movie_id_left - ∞ PROJECT movie_id - ∞ INNER JOIN HASH ON PROJECTION_2735.info_type_id = PROJECTION_2732.id - 1 │└PROJECT id - 1 │ FILTER (1 AND info = 'release dates'_String) AS a24 - 1 │ TABLE SCAN info_type WHERE info = 'release dates' - ∞ PROJECT info_type_id, movie_id - ∞ FILTER ( LIKE (note,'%internet%'_String) AND 1 AND OR ( LIKE (info,'USA:% 199%'_String), LIKE (info,'USA:% 200%'_String))) AS a10 - 1783 TABLE SCAN movie_info WHERE note LIKE '%internet%' AND (info LIKE 'USA:% 199%' OR info LIKE 'USA:% 200%')
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1) 0 628 PROJECT kind, title 0 628 INNER JOIN HASH ON id = keyword_id 0 628 │└INNER JOIN HASH ON movie_id = movie_id 0 7 │ │└INNER JOIN HASH ON id = company_type_id 0 7 │ │ │└INNER JOIN HASH ON info_type_id = id 2 1 │ │ │ │└FILTER id <= 110 2 1 │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates' 8 7 │ │ │ INNER JOIN HASH ON movie_id = movie_id 7 21851 │ │ │ │└INNER JOIN HASH ON status_id = id 1 1 │ │ │ │ │└FILTER id >= 3 1 1 │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'complete+verified' 28 53781 │ │ │ │ INNER JOIN HASH ON kind_id = id 1 4 │ │ │ │ │└FILTER (kind = 'movie') OR (kind = 'tv movie') OR (kind = 'video movie') OR (kind = 'video game') 7 7 │ │ │ │ │ TABLE SCAN kind_type WHERE kind IN('movie','tv movie','video movie','video game') 202 55341 │ │ │ │ INNER JOIN HASH ON id = movie_id 992 282816 │ │ │ │ │└INNER JOIN HASH ON movie_id = movie_id 18253 1153687 │ │ │ │ │ │└INNER JOIN HASH ON company_id = id 1644 84843 │ │ │ │ │ │ │└TABLE SCAN company_name WHERE country_code = 'us' 2609129 2608923 │ │ │ │ │ │ TABLE SCAN movie_companies WHERE movie_id >= 285 135086 132364 │ │ │ │ │ TABLE SCAN complete_cast WHERE movie_id <= 2525745 505662 11303 │ │ │ │ FILTER id BETWEEN 285 AND 2525745 505662 11303 │ │ │ │ TABLE SCAN title WHERE production_year > 1990 2967144 458 │ │ │ FILTER movie_id BETWEEN 285 AND 2525745 2967144 458 │ │ │ TABLE SCAN movie_info WHERE contains(note,'internet') AND (info IS NOT NULL) AND ((info LIKE 'USA:% 199%') OR (info LIKE 'USA:% 200%')) 4 2 │ │ TABLE SCAN company_type WHERE id <= 2 4523930 166 │ TABLE SCAN movie_keyword WHERE movie_id >= 285 AND movie_id <= 2525745 134170 210 TABLE SCAN keyword
	Estimate Actual Operator 1 1 PROJECT movie_kind, complete_us_internet_movie 1 1 AGGREGATE MIN(kind), MIN(title) 5905 10 DISTRIBUTE GATHER 5905 10 AGGREGATE MIN(kind), MIN(title) 5905 628 INNER JOIN HASH ON id = kind_id 2 4 │└DISTRIBUTE GATHER 2 4 │ FILTER kind IN('movie','tv movie','video movie','video game') 7 7 │ DISTRIBUTE ROUND ROBIN 7 7 │ TABLE SCAN kind_type WHERE kind IN('movie','tv movie','video movie','video game') 20669 628 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id 20669 628 │└DISTRIBUTE GATHER 20669 628 │ INNER JOIN HASH ON keyword_id = id 20669 628 │ │└DISTRIBUTE GATHER 20669 628 │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id 11541 7 │ │ │└DISTRIBUTE GATHER 11541 7 │ │ │ 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' 55198 7 │ │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id 47000 105289 │ │ │ │└DISTRIBUTE GATHER 47000 105289 │ │ │ │ INNER JOIN HASH ON id = company_type_id 4 4 │ │ │ │ │└TABLE SCAN company_type 47000 105289 │ │ │ │ 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' 69772 227682 │ │ │ │ INNER JOIN HASH ON movie_id = movie_id 67543 24592 │ │ │ │ │└DISTRIBUTE GATHER 67543 24592 │ │ │ │ │ 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' 135086 135086 │ │ │ │ │ DISTRIBUTE ROUND ROBIN 135086 135086 │ │ │ │ │ TABLE SCAN complete_cast WHERE ((status_id >= 4) AND (status_id <= 4)) AND status_id IN 4 2609129 2609129 │ │ │ │ TABLE SCAN movie_companies WHERE ((((movie_id >= 608) AND (movie_id <= 2528176)) AND TRUE) AND (((company_id >= 1) AND (company_id <= 234997)) AND TRUE)) AND (((company_type_id >= 1) AND (company_type_id <= 4)) AND company_type_id IN(1,2,3,4)) 2967144 1783 │ │ │ FILTER (note LIKE '%internet%' AND info IS NOT NULL) AND (info LIKE 'USA:% 199%' OR info LIKE 'USA:% 200%') 14835720 3212639 │ │ │ TABLE SCAN movie_info WHERE (((note LIKE '%internet%' AND info IS NOT NULL) AND (info LIKE 'USA:% 199%' OR info LIKE 'USA:% 200%')) AND ((((movie_id >= 608) AND (movie_id <= 2525620)) AND ((movie_id >= 608) AND (movie_id <= 2525620))) AND TRUE)) AND (((info_type_id >= 16) AND (info_type_id <= 16)) AND info_type_id IN 16) 4523930 3167679 │ │ TABLE SCAN movie_keyword WHERE ((((movie_id >= 1834062) AND (movie_id <= 2349630)) AND ((movie_id >= 1834062) AND (movie_id <= 2349630))) AND ((movie_id >= 1834062) AND (movie_id <= 2349630))) AND struct(movie_id,movie_id,movie_id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > ) 134170 134170 │ DISTRIBUTE ROUND ROBIN 134170 134170 │ TABLE SCAN keyword WHERE ((id >= 72) AND (id <= 124590)) AND TRUE 523722 718761 FILTER production_year > 1990 2528312 1174569 TABLE SCAN title WHERE ((production_year > 1990) AND ((((((id >= 1834062) AND (id <= 2349630)) AND ((id >= 1834062) AND (id <= 2349630))) AND ((id >= 1834062) AND (id <= 2349630))) AND ((id >= 1834062) AND (id <= 2349630))) AND struct(id,id,id,id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < exp...
	Estimate Actual Operator 1 1 AGGREGATE MIN(kt.kind), MIN(t.title) 1 1 DISTRIBUTE GATHER 1 1 AGGREGATE MIN(kt.kind), MIN(t.title) 113000 628 INNER JOIN HASH ON mk.keyword_id = k.id 113000 134170 │└DISTRIBUTE GATHER 14800000 134170 │ TABLE SCAN keyword 108000 628 INNER JOIN HASH ON cc.movie_id = mk.movie_id 108000 7 │└DISTRIBUTE GATHER 12100 7 │ INNER JOIN HASH ON mc.company_id = cn.id 12100 84843 │ │└DISTRIBUTE GATHER 135000 84843 │ │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND (cn.country_code = 'us') 258000 7 │ INNER JOIN HASH ON mc.company_type_id = ct.id 258000 4 │ │└DISTRIBUTE GATHER 4 4 │ │ TABLE SCAN company_type 258000 7 │ INNER JOIN HASH ON cc.movie_id = mc.movie_id 258000 6 │ │└DISTRIBUTE GATHER 101000 6 │ │ INNER JOIN HASH ON t.kind_id = kt.id 101000 4 │ │ │└DISTRIBUTE GATHER 7 4 │ │ │ TABLE SCAN kind_type WHERE kt.kind IN('movie','tv movie','video movie','video game') 101000 6 │ │ INNER JOIN HASH ON cc.movie_id = t.id 101000 6 │ │ │└DISTRIBUTE GATHER 96000 6 │ │ │ INNER JOIN HASH ON cc.status_id = cct1.id 96000 1 │ │ │ │└DISTRIBUTE GATHER 4 1 │ │ │ │ TABLE SCAN comp_cast_type WHERE cct1.kind = 'complete+verified' 192000 40 │ │ │ INNER JOIN HASH ON mi.movie_id = cc.movie_id 192000 135086 │ │ │ │└DISTRIBUTE GATHER 235000 135086 │ │ │ │ TABLE SCAN complete_cast WHERE cc.movie_id IS NOT NULL 192000 1753 │ │ │ INNER JOIN HASH ON mi.info_type_id = it1.id 192000 1 │ │ │ │└DISTRIBUTE GATHER 134000 1 │ │ │ │ TABLE SCAN info_type WHERE it1.info = 'release dates' 4520000 1753 │ │ │ TABLE SCAN movie_info WHERE (mi.note IS NOT NULL) AND contains(mi.note,'internet') AND (mi.info LIKE 'USA:% 199%' OR mi.info LIKE 'USA:% 200%') 2610000 368184 │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year > 1990L) 2530000 2007018 │ TABLE SCAN movie_companies 113 2885540 TABLE SCAN movie_keyword
	Estimate Actual Operator 1 1 AGGREGATE MIN(partialagg1053) AS Expr1022, MIN(partialagg1054) AS Expr1023 5 1 AGGREGATE MIN(kind as kind) AS partialagg1053, MIN(title as title) AS partialagg1054 519 628 INNER JOIN LOOP ON t.id = mk.movie_id 49 628 │└TABLE SEEK movie_keyword AS mk 10 7 FILTER country_code as country_code = 'us' 29 7 INNER JOIN LOOP ON Bmk1004 = Bmk1004 1 7 │└TABLE SEEK company_name AS cn 29 7 INNER JOIN LOOP ON mc.company_id = cn.id 1 7 │└TABLE SEEK company_name AS cn 29 7 INNER JOIN LOOP ON Bmk1014 = Bmk1014 1 7 │└TABLE SEEK movie_companies AS mc 29 7 PROJECT BmkToPage Bmk1014 AS Expr1064 29 7 INNER JOIN LOOP ON t.id = mc.movie_id 9 7 │└TABLE SEEK movie_companies AS mc 2 6 FILTER kind as kind = 'movie' OR kind as kind = 'tv movie' OR kind as kind = 'video game' OR kind as kind = 'video movie' 4 6 INNER JOIN LOOP ON Bmk1012 = Bmk1012 1 6 │└TABLE SEEK kind_type AS kt 4 6 INNER JOIN LOOP ON t.kind_id = kt.id 1 6 │└TABLE SEEK kind_type AS kt 4 6 INNER JOIN LOOP ON Bmk1020 = Bmk1020 0 6 │└TABLE SEEK title AS t WHERE production_year as production_year > 1990 6 6 PROJECT BmkToPage Bmk1020 AS Expr1063 6 6 INNER JOIN LOOP ON mi.movie_id = t.id 1 6 │└TABLE SEEK title AS t 6 6 FILTER kind as kind = 'complete+verified' 12 40 INNER JOIN LOOP ON Bmk1002 = Bmk1002 1 40 │└TABLE SEEK comp_cast_type AS cct1 12 40 INNER JOIN LOOP ON cc.status_id = cct1.id 1 40 │└TABLE SEEK comp_cast_type AS cct1 12 40 INNER JOIN LOOP ON Bmk1000 = Bmk1000 1 40 │└TABLE SEEK complete_cast AS cc 12 40 INNER JOIN LOOP ON mi.movie_id = cc.movie_id 1 40 │└TABLE SEEK complete_cast AS cc 24 1785 INNER JOIN MERGE ON id as id = info_type_id as info_type_id 1 1 │└SORT id 1 1 │ FILTER info as info = 'release dates' 113 113 │ TABLE SCAN info_type AS it1 1690 1785 SORT info_type_id 1690 1785 TABLE SEEK movie_info AS mi WHERE note as note LIKE '%internet%' AND (info as info LIKE 'USA:% 199%' OR info as info LIKE 'USA:% 200%')
	Estimate Actual Operator 1 ∞ PROJECT min AS movie_kind, min_50 AS complete_us_internet_movie 1 1 AGGREGATE MIN(min_51) AS min, MIN(min_52) AS min_50 - 16 DISTRIBUTE GATHER - 16 AGGREGATE MIN(kind_22) AS min_51, MIN(title) AS min_52 - 628 INNER JOIN HASH ON kind_id = id_21 7 4 │└DISTRIBUTE GATHER 7 4 │ PROJECT id AS id_21, kind AS kind_22 7 4 │ FILTER kind IN('movie','tv movie','video game','video movie') 7 4 │ TABLE SCAN kind_type - 628 INNER JOIN HASH ON movie_id = id_43 512448 519650 │└DISTRIBUTE HASH ON id_43 512448 519650 │ PROJECT id AS id_43, title, kind_id 512448 519650 │ FILTER production_year > 1990 512448 519650 │ TABLE SCAN title - 628 INNER JOIN HASH ON keyword_id = id_17 134170 134170 │└DISTRIBUTE GATHER 134170 134170 │ PROJECT id AS id_17 134170 134170 │ TABLE SCAN keyword - 628 INNER JOIN HASH ON movie_id = movie_id_39 4523930 4523930 │└DISTRIBUTE HASH ON movie_id_39 4523930 4523930 │ PROJECT movie_id AS movie_id_39, keyword_id 4523930 4523930 │ TABLE SCAN movie_keyword - 7 INNER JOIN HASH ON info_type_id = id_13 113 1 │└DISTRIBUTE GATHER 113 1 │ PROJECT id AS id_13 113 1 │ FILTER info = 'release dates' 113 1 │ TABLE SCAN info_type - 7 INNER JOIN HASH ON movie_id = movie_id_32 13352148 1783 │└DISTRIBUTE HASH ON movie_id_32 13352148 1783 │ PROJECT movie_id AS movie_id_32, info_type_id 13352148 1783 │ FILTER (info >= 'USA:') AND (info < 'USA;') AND (note LIKE '%internet%') AND ((info LIKE 'USA:% 199%') OR (info LIKE 'USA:% 200%')) 13352148 1783 │ TABLE SCAN movie_info - 5 INNER JOIN HASH ON company_type_id = id_8 4 4 │└DISTRIBUTE GATHER 4 4 │ PROJECT id AS id_8 4 4 │ TABLE SCAN company_type - 5 INNER JOIN HASH ON company_id = id_4 234997 84843 │└DISTRIBUTE GATHER 234997 84843 │ PROJECT id AS id_4 234997 84843 │ FILTER country_code = 'us' 234997 84843 │ TABLE SCAN company_name - 5 INNER JOIN HASH ON movie_id = movie_id_27 2609129 2675 │└DISTRIBUTE HASH ON movie_id_27 2609129 2675 │ PROJECT movie_id AS movie_id_27, company_id, company_type_id 2609129 2675 │ TABLE SCAN movie_companies - 4 INNER JOIN HASH ON status_id = id_0 4 1 │└DISTRIBUTE GATHER 4 1 │ PROJECT id AS id_0 4 1 │ FILTER kind = 'complete+verified' 4 1 │ TABLE SCAN comp_cast_type 135086 4 TABLE SCAN complete_cast
	Estimate Actual Operator 1 1 AGGREGATE MIN(kind), MIN(title) 5 628 INNER JOIN LOOP ON id = keyword_id 5 628 │└INNER JOIN LOOP ON movie_id = id 1 7 │ │└INNER JOIN LOOP ON id = company_type_id AND (id = company_type_id) 1 7 │ │ │└INNER JOIN LOOP ON id = company_id 1 7 │ │ │ │└INNER JOIN LOOP ON movie_id = id 1 6 │ │ │ │ │└INNER JOIN LOOP ON id = info_type_id 14 6 │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = id 13297 5053 │ │ │ │ │ │ │└INNER JOIN HASH ON kind_id = id 4 4 │ │ │ │ │ │ │ │└TABLE SCAN kind_type AS kt WHERE kt.kind IN('movie','tv movie','video movie','video game') 23269 6424 │ │ │ │ │ │ │ INNER JOIN LOOP ON id = movie_id 33772 24592 │ │ │ │ │ │ │ │└INNER JOIN HASH ON status_id = id 1 1 │ │ │ │ │ │ │ │ │└TABLE SCAN comp_cast_type AS cct1 WHERE cct1.kind = 'complete+verified' 135086 135086 │ │ │ │ │ │ │ │ TABLE SCAN complete_cast AS cc 24592 24592 │ │ │ │ │ │ │ TABLE SEEK title AS t WHERE t.production_year > 1990 5053 5053 │ │ │ │ │ │ TABLE SEEK movie_info AS mi WHERE (mi.note LIKE '%internet%') AND ((mi.info LIKE 'USA:% 199%') OR (mi.info LIKE 'USA:% 200%')) 6 6 │ │ │ │ │ TABLE SEEK info_type AS it1 WHERE it1.info = 'release dates' 30 7 │ │ │ │ TABLE SEEK movie_companies AS mc 7 7 │ │ │ TABLE SEEK company_name AS cn WHERE cn.country_code = 'us' 4 1 │ │ TABLE SCAN company_type AS ct 315 627 │ TABLE SEEK movie_keyword AS mk 628 628 TABLE SEEK keyword AS k