Planner — IMDB — JOB-23B

SELECT MIN(kt.kind) AS movie_kind,
       MIN(t.title) AS complete_nerdy_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 k.keyword IN ('nerd',
                    'loner',
                    'alienation',
                    'dignity')
  AND kt.kind IN ('movie')
  AND mi.note LIKE '%internet%'
  AND mi.info LIKE 'USA:% 200%'
  AND t.production_year > 2000
  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,523,952 4.5M Rank		Estimation Error Est Err 4,524,056 4.5M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 2,381 2.4K Rank	Estimation Error Est Err 16 16 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 8,785,552 8.8M Rank		Estimation Error Est Err 9,284,593 9.3M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 10,746,465 11M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 7,334,626 7.3M Rank		Estimation Error Est Err 7,253,125 7.3M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 93,707 94K Rank	Estimation Error Est Err 17 17 Rank	Estimation Error Est Err 88,137 88K Rank
Estimation Error Est Err 9,125,188 9.1M Rank		Estimation Error Est Err 5,747,163 5.7M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 569,415 569K Rank	Estimation Error Est Err 26 26 Rank	Estimation Error Est Err 484,757 485K Rank
Estimation Error Est Err 8,559 8.6K Rank		Estimation Error Est Err 3,312 3.3K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 4,882 4.9K Rank	Estimation Error Est Err 16 16 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 5,441 5.4K Rank	Estimation Error Est Err 5,438 5.4K Rank	Estimation Error Est Err 6,447 6.4K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 6,210 6.2K Rank	Estimation Error Est Err 16 16 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 25,465 25K Rank	Estimation Error Est Err 25,460 25K Rank	Estimation Error Est Err 26,593 27K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 26,593 27K Rank	Estimation Error Est Err 16 16 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 368,356 368K Rank		Estimation Error Est Err 80 80 Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 368,386 368K Rank	Estimation Error Est Err 32 32 Rank	Estimation Error Est Err 368,370 368K Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min 1 16 INNER JOIN HASH ON id = company_type_id 4 4 │└TABLE SCAN company_type 3 16 INNER JOIN HASH ON id71 = company_id 7 16 │└INNER JOIN HASH ON id41 = movie_id64 1 16 │ │└INNER JOIN HASH ON id6 = info_type_id 1 1 │ │ │└TABLE SCAN info_type WHERE info = release dates 1 16 │ │ INNER JOIN HASH ON id11 = status_id 1 1 │ │ │└TABLE SCAN comp_cast_type WHERE kind = complete + verified 1 16 │ │ INNER JOIN HASH ON id41 = movie_id57 1 9 │ │ │└INNER JOIN HASH ON id16 = kind_id 1 1 │ │ │ │└TABLE SCAN kind_type WHERE kind = movie 2 10 │ │ │ INNER JOIN HASH ON id41 = movie_id34 3 10 │ │ │ │└INNER JOIN HASH ON movie_id = movie_id34 129 1133 │ │ │ │ │└INNER JOIN HASH ON id21 = keyword_id 4 4 │ │ │ │ │ │└TABLE SCAN keyword WHERE keyword IN(alienation,dignity,loner,nerd) 4523930 4523930 │ │ │ │ │ TABLE SCAN movie_keyword 5129 4 │ │ │ │ TABLE SCAN movie_info WHERE info) USA : AND note LIKE '%internet%' AND info36 LIKE '% 200%' 1402423 3 │ │ │ TABLE SCAN title WHERE production_year >= 2001 135086 2 │ │ TABLE SCAN complete_cast 2076277 1 │ TABLE SCAN movie_companies 90648 1 TABLE SCAN company_name WHERE country_code = us
	Estimate Actual Operator - 1 PROJECT a1 AS movie_kind, a2 AS complete_nerdy_internet_movie - 1 AGGREGATE MIN(kind) AS a1, MIN(title) AS a2 - 0 PROJECT kind, title - 0 PROJECT title, kind - 0 INNER JOIN HASH ON tuple(PROJECTION_2634.movie_id,PROJECTION_2634.movie_id,PROJECTION_2634.movie_id,PROJECTION_2634.movie_id,PROJECTION_2634.movie_id,PROJECTION_2634.movie_id) = tuple(PROJECTION_2613.movie_id,PROJECTION_2613.movie_id,PROJECTION_2613.movie_id,PROJECTION_2613.id,PROJECTION_2613.id,PROJECTION_2613.id) - 1970380 │└PROJECT movie_id AS movie_id_right, id, title, kind - 1970380 │ PROJECT movie_id, title, id, kind - 1970380 │ INNER JOIN HASH ON PROJECTION_2619.kind_id = PROJECTION_2616.id - 7 │ │└PROJECT id AS id_right, kind - 7 │ │ PROJECT id, kind - 7 │ │ TABLE SCAN kind_type WHERE TRUE - 1970380 │ PROJECT kind_id, movie_id, title, id_left - 1970380 │ PROJECT movie_id, title, id, kind_id - 1970380 │ INNER JOIN HASH ON PROJECTION_2625.keyword_id = PROJECTION_2622.id - 134170 │ │└PROJECT id AS id_right - 134170 │ │ PROJECT id - 134170 │ │ TABLE SCAN keyword WHERE TRUE - 1970380 │ PROJECT keyword_id, movie_id, title, id AS id_left, kind_id - 1970380 │ PROJECT movie_id, keyword_id, title, id, kind_id - 1970380 │ INNER JOIN HASH ON PROJECTION_2631.movie_id = PROJECTION_2628.id - 1381453 │ │└PROJECT id, title, kind_id - 1381453 │ │ PROJECT id, title, kind_id - 1381453 │ │ TABLE SCAN title WHERE production_year > 2000 - 4523930 │ PROJECT movie_id, keyword_id - 4523930 │ PROJECT movie_id, keyword_id - 4523930 │ TABLE SCAN movie_keyword - 0 PROJECT movie_id AS movie_id_left, movie_id AS movie_id_left_2, movie_id AS movie_id_left_3 - 0 PROJECT movie_id, movie_id, movie_id - 0 INNER JOIN HASH ON tuple(PROJECTION_2646.movie_id,PROJECTION_2646.movie_id) = tuple(PROJECTION_2637.movie_id,PROJECTION_2637.movie_id) - 1771 │└PROJECT movie_id AS movie_id_right - 1771 │ PROJECT movie_id - 1771 │ INNER JOIN HASH ON PROJECTION_2643.info_type_id = PROJECTION_2640.id - 1 │ │└PROJECT id - 1 │ │ PROJECT id - 1 │ │ TABLE SCAN info_type WHERE info = 'release dates' - 1771 │ PROJECT info_type_id, movie_id - 1771 │ PROJECT movie_id, info_type_id - 1771 │ TABLE SCAN movie_info WHERE note LIKE '%internet%' AND info LIKE 'USA:% 200%' - 0 PROJECT movie_id_left, movie_id AS movie_id_left_2 - 0 PROJECT movie_id, movie_id - 0 INNER JOIN HASH ON PROJECTION_2652.company_id = PROJECTION_2649.id - 0 │└PROJECT id - 0 │ PROJECT id - 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_2658.company_type_id = PROJECTION_2655.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_2664.movie_id = PROJECTION_2661.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_2670.status_id = PROJECTION_2667.id - 1 │└PROJECT id - 1 │ PROJECT id - 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
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1) 0 16 PROJECT kind, title 0 16 INNER JOIN HASH ON id = company_type_id 0 16 │└INNER JOIN HASH ON id = keyword_id 0 618 │ │└INNER JOIN HASH ON movie_id = movie_id 0 6 │ │ │└INNER JOIN HASH ON id = company_id 4 6 │ │ │ │└INNER JOIN HASH ON movie_id = movie_id 4 5 │ │ │ │ │└INNER JOIN HASH ON status_id = id 1 1 │ │ │ │ │ │└FILTER id >= 3 1 1 │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'complete+verified' 16 32 │ │ │ │ │ INNER JOIN HASH ON kind_id = id 1 1 │ │ │ │ │ │└TABLE SCAN kind_type WHERE kind = 'movie' 116 32 │ │ │ │ │ INNER JOIN HASH ON id = movie_id 571 39 │ │ │ │ │ │└INNER JOIN HASH ON movie_id = movie_id 10503 1771 │ │ │ │ │ │ │└INNER JOIN HASH ON info_type_id = id 2 1 │ │ │ │ │ │ │ │└FILTER id <= 110 2 1 │ │ │ │ │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates' 593428 1771 │ │ │ │ │ │ │ FILTER movie_id BETWEEN 285 AND 2525745 593428 1771 │ │ │ │ │ │ │ FILTER info LIKE 'USA:% 200%' 2967144 7380 │ │ │ │ │ │ │ TABLE SCAN movie_info WHERE contains(note,'internet') AND info >= 'USA:' AND info < 'USA;' 135086 584 │ │ │ │ │ │ FILTER movie_id <= 2525745 135086 584 │ │ │ │ │ │ TABLE SCAN complete_cast WHERE movie_id <= 2526430 505662 231 │ │ │ │ │ FILTER id BETWEEN 285 AND 2525745 505662 231 │ │ │ │ │ TABLE SCAN title WHERE production_year > 2000 2609129 3 │ │ │ │ TABLE SCAN movie_companies WHERE movie_id >= 285 1644 3 │ │ │ TABLE SCAN company_name WHERE country_code = 'us' 4523930 156 │ │ TABLE SCAN movie_keyword WHERE movie_id >= 285 AND movie_id <= 2525745 26834 4 │ FILTER (keyword = 'nerd') OR (keyword = 'loner') OR (keyword = 'alienation') OR (keyword = 'dignity') 134170 198 │ TABLE SCAN keyword WHERE keyword IN('nerd','loner','alienation','dignity') 4 1 TABLE SCAN company_type WHERE id <= 2
	Estimate Actual Operator 1 1 PROJECT movie_kind, complete_nerdy_internet_movie 1 1 AGGREGATE MIN(kind), MIN(title) 5905 10 DISTRIBUTE GATHER 5905 10 AGGREGATE MIN(kind), MIN(title) 5905 16 INNER JOIN HASH ON id = kind_id 2 1 │└DISTRIBUTE GATHER 2 1 │ FILTER kind = 'movie' 7 7 │ DISTRIBUTE ROUND ROBIN 7 7 │ TABLE SCAN kind_type WHERE kind = 'movie' 20669 16 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id 20669 16 │└DISTRIBUTE GATHER 20669 16 │ INNER JOIN HASH ON keyword_id = id 20669 618 │ │└DISTRIBUTE GATHER 20669 618 │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id 11541 6 │ │ │└DISTRIBUTE GATHER 11541 6 │ │ │ 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 6 │ │ │ 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 1771 │ │ │ FILTER note LIKE '%internet%' AND info LIKE 'USA:% 200%' 14835720 3212639 │ │ │ TABLE SCAN movie_info WHERE ((note LIKE '%internet%' AND 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 2553279 │ │ TABLE SCAN movie_keyword WHERE ((((movie_id >= 2344754) AND (movie_id <= 2349630)) AND ((movie_id >= 2344754) AND (movie_id <= 2349630))) AND ((movie_id >= 2344754) AND (movie_id <= 2349630))) AND struct(movie_id,movie_id,movie_id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > ) 26834 4 │ FILTER keyword IN('nerd','loner','alienation','dignity') 134170 134170 │ DISTRIBUTE ROUND ROBIN 134170 134170 │ TABLE SCAN keyword WHERE keyword IN('nerd','loner','alienation','dignity') AND (((id >= 72) AND (id <= 124590)) AND TRUE) 343129 114889 FILTER production_year > 2000 2528312 245760 TABLE SCAN title WHERE ((production_year > 2000) AND ((((((id >= 2349630) AND (id <= 2349630)) AND ((id >= 2349630) AND (id <= 2349630))) AND ((id >= 2349630) AND (id <= 2349630))) AND ((id >= 2349630) 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 > ))) AND (((kind_id >= 1) AND (kind_id <= 1)) AND ki...
	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) 4540 16 INNER JOIN HASH ON cc.movie_id = mi.movie_id 4540 1771 │└DISTRIBUTE GATHER 698 1771 │ INNER JOIN HASH ON mi.info_type_id = it1.id 698 1 │ │└DISTRIBUTE GATHER 135000 1 │ │ TABLE SCAN info_type WHERE it1.info = 'release dates' 4520000 1771 │ TABLE SCAN movie_info WHERE (mi.note IS NOT NULL) AND contains(mi.note,'internet') AND mi.info LIKE 'USA:% 200%' 721 315 INNER JOIN HASH ON mc.company_id = cn.id 721 84843 │└DISTRIBUTE GATHER 134000 84843 │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND (cn.country_code = 'us') 698 1180 INNER JOIN HASH ON mc.company_type_id = ct.id 698 4 │└DISTRIBUTE GATHER 4 4 │ TABLE SCAN company_type 273 1180 INNER JOIN HASH ON cc.movie_id = mc.movie_id 273 60 │└DISTRIBUTE GATHER 273 60 │ INNER JOIN HASH ON t.kind_id = kt.id 273 1 │ │└DISTRIBUTE GATHER 7 1 │ │ TABLE SCAN kind_type WHERE kt.kind = 'movie' 259 61 │ INNER JOIN HASH ON cc.movie_id = t.id 259 318 │ │└DISTRIBUTE GATHER 259 318 │ │ INNER JOIN HASH ON cc.status_id = cct1.id 259 1 │ │ │└DISTRIBUTE GATHER 235000 1 │ │ │ TABLE SCAN comp_cast_type WHERE cct1.kind = 'complete+verified' 176 617 │ │ INNER JOIN HASH ON mk.movie_id = cc.movie_id 176 1133 │ │ │└DISTRIBUTE GATHER 168000 1133 │ │ │ INNER JOIN HASH ON mk.keyword_id = k.id 168000 4 │ │ │ │└DISTRIBUTE GATHER 113 4 │ │ │ │ TABLE SCAN keyword WHERE k.keyword IN('nerd','loner','alienation','dignity') 14800000 4519835 │ │ │ TABLE SCAN movie_keyword 4 131002 │ │ TABLE SCAN complete_cast WHERE cc.movie_id IS NOT NULL 2610000 414012 │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year > 2000L) 2530000 2183152 TABLE SCAN movie_companies
	Estimate Actual Operator 1 1 AGGREGATE MIN(kind as kind) AS Expr1022, MIN(title as title) AS Expr1023 1 16 FILTER country_code as country_code = 'us' 9 16 INNER JOIN LOOP ON Bmk1004 = Bmk1004 1 16 │└TABLE SEEK company_name AS cn 9 16 INNER JOIN LOOP ON mc.company_id = cn.id 1 16 │└TABLE SEEK company_name AS cn 9 16 INNER JOIN LOOP ON Bmk1014 = Bmk1014 1 16 │└TABLE SEEK movie_companies AS mc 9 16 PROJECT BmkToPage Bmk1014 AS Expr1079 9 16 INNER JOIN LOOP ON t.id = mc.movie_id 9 16 │└TABLE SEEK movie_companies AS mc 1 16 FILTER kind as kind = 'movie' 1 16 INNER JOIN LOOP ON Bmk1012 = Bmk1012 1 16 │└TABLE SEEK kind_type AS kt 1 16 INNER JOIN LOOP ON t.kind_id = kt.id 1 16 │└TABLE SEEK kind_type AS kt 1 16 INNER JOIN LOOP ON Bmk1020 = Bmk1020 1 16 │└TABLE SEEK title AS t WHERE production_year as production_year > 2000 1 16 PROJECT BmkToPage Bmk1020 AS Expr1078 1 16 INNER JOIN LOOP ON mk.movie_id = t.id 1 16 │└TABLE SEEK title AS t 1 16 FILTER kind as kind = 'complete+verified' 1 16 INNER JOIN LOOP ON Bmk1002 = Bmk1002 1 16 │└TABLE SEEK comp_cast_type AS cct1 1 16 INNER JOIN LOOP ON cc.status_id = cct1.id 1 16 │└TABLE SEEK comp_cast_type AS cct1 1 16 INNER JOIN LOOP ON Bmk1000 = Bmk1000 1 16 │└TABLE SEEK complete_cast AS cc 1 16 INNER JOIN LOOP ON mk.movie_id = cc.movie_id 1 16 │└TABLE SEEK complete_cast AS cc 1 10 FILTER note as note LIKE '%internet%' AND info as info LIKE 'USA:% 200%' 308 11501 INNER JOIN LOOP ON mi.movie_id = mi.movie_id AND Uniq1017 = Uniq1017 1 11501 │└TABLE SEEK movie_info AS mi 308 11501 INNER JOIN LOOP ON it1.id = mi.info_type_id AND mk.movie_id = mi.movie_id 1 11501 │└TABLE SEEK movie_info AS mi 362 1133 INNER JOIN LOOP ON info as info = 'release dates' 1 1 │└MATERIALISE AS m39 1 1 │ TABLE SCAN info_type AS it1 WHERE info as info = 'release dates' 362 1133 INNER JOIN LOOP ON Bmk1018 = Bmk1018 1 1133 │└TABLE SEEK movie_keyword AS mk 362 1133 INNER JOIN LOOP ON k.id = mk.keyword_id 90 1133 │└TABLE SEEK movie_keyword AS mk 4 4 TABLE SCAN keyword AS k WHERE keyword as keyword = 'alienation' OR keyword as keyword = 'dignity' OR keyword as keyword = 'loner' OR keyword as keyword = 'nerd'
	Estimate Actual Operator 1 ∞ PROJECT min AS movie_kind, min_50 AS complete_nerdy_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 - 16 INNER JOIN HASH ON kind_id = id_21 7 1 │└DISTRIBUTE GATHER 7 1 │ PROJECT id AS id_21, kind AS kind_22 7 1 │ FILTER kind = 'movie' 7 1 │ TABLE SCAN kind_type - 16 INNER JOIN HASH ON movie_id = id_43 335742 283091 │└DISTRIBUTE HASH ON id_43 335742 283091 │ PROJECT id AS id_43, title, kind_id 335742 283091 │ FILTER production_year > 2000 335742 283091 │ TABLE SCAN title - 16 INNER JOIN HASH ON keyword_id = id_17 134170 4 │└DISTRIBUTE GATHER 134170 4 │ PROJECT id AS id_17 134170 4 │ FILTER keyword IN('alienation','dignity','loner','nerd') 134170 4 │ TABLE SCAN keyword - 16 INNER JOIN HASH ON movie_id = movie_id_39 4523930 404 │└DISTRIBUTE HASH ON movie_id_39 4523930 404 │ PROJECT movie_id AS movie_id_39, keyword_id 4523930 404 │ TABLE SCAN movie_keyword - 4 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 - 4 INNER JOIN HASH ON movie_id = movie_id_32 13352148 3 │└DISTRIBUTE HASH ON movie_id_32 13352148 3 │ PROJECT movie_id AS movie_id_32, info_type_id 13352148 3 │ FILTER (info >= 'USA:') AND (info < 'USA;') AND (note LIKE '%internet%') AND (info LIKE 'USA:% 200%') 13352148 3 │ TABLE SCAN movie_info - 2 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 - 2 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 - 2 INNER JOIN HASH ON movie_id = movie_id_27 2609129 2 │└DISTRIBUTE HASH ON movie_id_27 2609129 2 │ PROJECT movie_id AS movie_id_27, company_id, company_type_id 2609129 2 │ TABLE SCAN movie_companies - 2 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 2 TABLE SCAN complete_cast
	Estimate Actual Operator 1 1 AGGREGATE MIN(kind), MIN(title) 1 16 INNER JOIN LOOP ON id = info_type_id 1 16 │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 315 │ │└INNER JOIN LOOP ON id = company_type_id AND (id = company_type_id) 1 315 │ │ │└INNER JOIN LOOP ON id = company_id 3 1218 │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 4 60 │ │ │ │ │└INNER JOIN LOOP ON keyword IN('nerd','loner','alienation','dignity') AND id = status_id AND (id = status_id) 1 1 │ │ │ │ │ │└TABLE SCAN comp_cast_type AS cct1 WHERE cct1.kind = 'complete+verified' 14 141 │ │ │ │ │ INNER JOIN LOOP ON movie_id = id 10 401 │ │ │ │ │ │└INNER JOIN LOOP ON keyword IN('nerd','loner','alienation','dignity') AND id = kind_id AND (id = kind_id) 1 1 │ │ │ │ │ │ │└TABLE SCAN kind_type AS kt WHERE kt.kind = 'movie' 73 557 │ │ │ │ │ │ INNER JOIN LOOP ON id = movie_id 135 1133 │ │ │ │ │ │ │└INNER JOIN LOOP ON keyword_id = id 4 4 │ │ │ │ │ │ │ │└TABLE SEEK keyword AS k 1220 1133 │ │ │ │ │ │ │ TABLE SEEK movie_keyword AS mk 1133 1133 │ │ │ │ │ │ TABLE SEEK title AS t WHERE t.production_year > 2000 802 401 │ │ │ │ │ TABLE SEEK complete_cast AS cc 300 1218 │ │ │ │ TABLE SEEK movie_companies AS mc 1218 1218 │ │ │ TABLE SEEK company_name AS cn WHERE cn.country_code = 'us' 4 1 │ │ TABLE SCAN company_type AS ct 315 315 │ TABLE SEEK movie_info AS mi WHERE (mi.note LIKE '%internet%') AND (mi.info LIKE 'USA:% 200%') 16 16 TABLE SEEK info_type AS it1 WHERE it1.info = 'release dates'