Planner — IMDB — JOB-27C

SELECT MIN(cn.name) AS producing_company,
       MIN(lt.link) AS link_type,
       MIN(t.title) AS complete_western_sequel
FROM job.complete_cast AS cc,
     job.comp_cast_type AS cct1,
     job.comp_cast_type AS cct2,
     job.company_name AS cn,
     job.company_type AS ct,
     job.keyword AS k,
     job.link_type AS lt,
     job.movie_companies AS mc,
     job.movie_info AS mi,
     job.movie_keyword AS mk,
     job.movie_link AS ml,
     job.title AS t
WHERE cct1.kind = 'cast'
  AND cct2.kind LIKE 'complete%'
  AND cn.country_code !='[pl]'
  AND (cn.name LIKE '%Film%'
       OR cn.name LIKE '%Warner%')
  AND ct.kind ='production companies'
  AND k.keyword ='sequel'
  AND lt.link LIKE '%follow%'
  AND mc.note IS NULL
  AND mi.info IN ('Sweden',
                  'Norway',
                  'Germany',
                  'Denmark',
                  'Swedish',
                  'Denish',
                  'Norwegian',
                  'German',
                  'English')
  AND t.production_year BETWEEN 1950 AND 2010
  AND lt.id = ml.link_type_id
  AND ml.movie_id = t.id
  AND t.id = mk.movie_id
  AND mk.keyword_id = k.id
  AND t.id = mc.movie_id
  AND mc.company_type_id = ct.id
  AND mc.company_id = cn.id
  AND mi.movie_id = t.id
  AND t.id = cc.movie_id
  AND cct1.id = cc.subject_id
  AND cct2.id = cc.status_id
  AND ml.movie_id = mk.movie_id
  AND ml.movie_id = mc.movie_id
  AND mk.movie_id = mc.movie_id
  AND ml.movie_id = mi.movie_id
  AND mk.movie_id = mi.movie_id
  AND mc.movie_id = mi.movie_id
  AND ml.movie_id = cc.movie_id
  AND mk.movie_id = cc.movie_id
  AND mc.movie_id = cc.movie_id
  AND mi.movie_id = cc.movie_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,554,071 4.6M Rank		Estimation Error Est Err 4,560,789 4.6M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 29,183 29K Rank	Estimation Error Est Err 743 743 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 25,031,371 25M 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,742,854 8.7M Rank		Estimation Error Est Err 7,787,673 7.8M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 1,004,001 1M Rank	Estimation Error Est Err 744 744 Rank	Estimation Error Est Err 983,723 984K Rank
Estimation Error Est Err 17,624,063 18M Rank		Estimation Error Est Err 9,301,585 9.3M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 1,133,807 1.1M Rank	Estimation Error Est Err 753 753 Rank	Estimation Error Est Err 509,787 510K Rank
Estimation Error Est Err 479 479 Rank		Estimation Error Est Err 2,832 2.8K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 3,359 3.4K Rank	Estimation Error Est Err 743 743 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 47,529 48K Rank	Estimation Error Est Err 47,527 48K Rank	Estimation Error Est Err 48,028 48K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 47,725 48K Rank	Estimation Error Est Err 743 743 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 36,074 36K Rank	Estimation Error Est Err 36,073 36K Rank	Estimation Error Est Err 36,175 36K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 46,367 46K Rank	Estimation Error Est Err 743 743 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 1,951,110 2M Rank		Estimation Error Est Err 2,391 2.4K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 1,951,911 2M Rank	Estimation Error Est Err 759 759 Rank	Estimation Error Est Err 1,951,121 2M Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min, min 1 743 INNER JOIN HASH ON company_type_id = id 1 1 │└TABLE SCAN company_type WHERE kind = production companies 1 838 INNER JOIN HASH ON id6 = status_id 2 2 │└TABLE SCAN comp_cast_type WHERE kind) complete 1 838 INNER JOIN HASH ON company_id = id78 4 1913 │└INNER JOIN HASH ON movie_id41 = movie_id71 1 251 │ │└INNER JOIN HASH ON id11 = subject_id 1 1 │ │ │└TABLE SCAN comp_cast_type WHERE kind = cast 1 346 │ │ INNER JOIN HASH ON movie_id41 = movie_id64 1 746 │ │ │└INNER JOIN HASH ON movie_id41 = id48 1 746 │ │ │ │└INNER JOIN HASH ON movie_id34 = movie_id41 1 199 │ │ │ │ │└INNER JOIN HASH ON id16 = link_type_id 2 2 │ │ │ │ │ │└TABLE SCAN link_type WHERE link LIKE '%follow%' 2 251 │ │ │ │ │ INNER JOIN HASH ON movie_id34 = movie_id 32 10544 │ │ │ │ │ │└INNER JOIN HASH ON keyword_id = id21 1 1 │ │ │ │ │ │ │└TABLE SCAN keyword WHERE keyword = sequel 4523930 4523930 │ │ │ │ │ │ TABLE SCAN movie_keyword 29997 29997 │ │ │ │ │ TABLE SCAN movie_link 898256 57 │ │ │ │ TABLE SCAN movie_info WHERE info BETWEEN Denish AND Swedish AND info IN(Denish,Denmark,English,German,Germany,Norway,Norwegian,Sweden,Swedish) 1923393 25 │ │ │ TABLE SCAN title WHERE production_year BETWEEN 1950 AND 2010 101431 11 │ │ TABLE SCAN complete_cast 1203251 37 │ TABLE SCAN movie_companies WHERE note IS NULL 51405 7 TABLE SCAN company_name WHERE name LIKE '%Film%' OR name LIKE '%Warner%' AND country_code <> pl
	Estimate Actual Operator - ∞ PROJECT a1 AS producing_company, a2 AS link_type, a3 AS complete_western_sequel - ∞ AGGREGATE MIN(name) AS a1, MIN(link) AS a2, MIN(title) AS a3 - ∞ PROJECT name, link, title - ∞ FILTER 0 - ∞ PROJECT name, link, title - ∞ INNER JOIN HASH ON TRUE - 0 │└PROJECT title - 0 │ FILTER 0 - 2528312 │ TABLE SCAN title - ∞ PROJECT name, link - ∞ FILTER 0 - ∞ PROJECT name, link - ∞ INNER JOIN HASH ON TRUE - 0 │└PROJECT id - 0 │ FILTER 0 - 29997 │ TABLE SCAN movie_link - ∞ PROJECT name, link - ∞ FILTER 0 - ∞ PROJECT name, link - ∞ INNER JOIN HASH ON TRUE - 0 │└PROJECT movie_id - 0 │ FILTER 0 - 4523930 │ TABLE SCAN movie_keyword - ∞ PROJECT name, link - ∞ FILTER 0 - ∞ PROJECT name, link - ∞ INNER JOIN HASH ON TRUE - 0 │└PROJECT info_type_id - 0 │ FILTER 0 - 14835720 │ TABLE SCAN movie_info - ∞ PROJECT name, link - ∞ FILTER 0 - ∞ PROJECT name, link - ∞ INNER JOIN HASH ON TRUE - 0 │└PROJECT company_type_id - 0 │ FILTER 0 - 2609129 │ TABLE SCAN movie_companies - ∞ PROJECT name, link - ∞ FILTER 0 - ∞ PROJECT name, link - ∞ INNER JOIN HASH ON TRUE - 0 │└PROJECT link - 0 │ FILTER 0 - 18 │ TABLE SCAN link_type - ∞ PROJECT name - ∞ FILTER 0 - ∞ PROJECT name - ∞ INNER JOIN HASH ON TRUE - 0 │└PROJECT id - 0 │ FILTER 0 - 134170 │ TABLE SCAN keyword - ∞ PROJECT name - ∞ FILTER 0 - ∞ PROJECT name - ∞ INNER JOIN HASH ON TRUE - 0 │└PROJECT id - 0 │ FILTER 0 - 4 │ TABLE SCAN company_type - ∞ PROJECT name - ∞ FILTER 0 - ∞ PROJECT name - ∞ INNER JOIN HASH ON TRUE - 0 │└PROJECT name - 0 │ FILTER 0 - 234997 │ PROJECT name - 234997 │ TABLE SCAN company_name - ∞ PROJECT __join_result_dummy - ∞ FILTER 0 - ∞ PROJECT __join_result_dummy - ∞ INNER JOIN HASH ON PROJECTION_3489.__lhs_const = PROJECTION_3486.__rhs_const - ∞ │└PROJECT __rhs_const, id AS id_right - 4 │ PROJECT id - 4 │ TABLE SCAN comp_cast_type - ∞ PROJECT __lhs_const, __join_result_dummy, id_left - 540344 PROJECT id - 540344 INNER JOIN HASH ON TRUE - 4 │└PROJECT id AS id_right - 4 │ PROJECT id - 4 │ TABLE SCAN comp_cast_type - 135086 PROJECT id AS id_left - 135086 PROJECT id - 135086 TABLE SCAN complete_cast
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1), MIN(#2) 0 743 PROJECT name, link, title 0 743 INNER JOIN HASH ON movie_id = id 0 172 │└INNER JOIN HASH ON id = company_type_id 0 191 │ │└INNER JOIN HASH ON id = status_id 0 191 │ │ │└INNER JOIN HASH ON id = subject_id 0 248 │ │ │ │└INNER JOIN HASH ON id = company_id 0 581 │ │ │ │ │└INNER JOIN HASH ON movie_id = id 0 98 │ │ │ │ │ │└INNER JOIN HASH ON id = movie_id 0 98 │ │ │ │ │ │ │└INNER JOIN HASH ON id = link_type_id 0 119 │ │ │ │ │ │ │ │└INNER JOIN HASH ON movie_id = movie_id 0 251 │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON movie_id = movie_id 69 46 │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON keyword_id = id 2 1 │ │ │ │ │ │ │ │ │ │ │└TABLE SCAN keyword WHERE keyword = 'sequel' 4523930 46 │ │ │ │ │ │ │ │ │ │ FILTER movie_id >= 285 4523930 46 │ │ │ │ │ │ │ │ │ │ TABLE SCAN movie_keyword WHERE movie_id <= 186175 29997 286 │ │ │ │ │ │ │ │ │ TABLE SCAN movie_link WHERE movie_id >= 285 135086 13 │ │ │ │ │ │ │ │ TABLE SCAN complete_cast WHERE movie_id <= 186175 3 2 │ │ │ │ │ │ │ FILTER id <= 17 3 2 │ │ │ │ │ │ │ TABLE SCAN link_type WHERE contains(link,'follow') 505662 12 │ │ │ │ │ │ FILTER id BETWEEN 285 AND 186175 505662 14 │ │ │ │ │ │ TABLE SCAN title WHERE production_year >= 1950 AND production_year <= 2010 521825 38 │ │ │ │ │ FILTER movie_id BETWEEN 285 AND 186175 521825 38 │ │ │ │ │ TABLE SCAN movie_companies WHERE note IS NULL 46999 7 │ │ │ │ TABLE SCAN company_name WHERE country_code != 'pl' AND (contains(name,'Film') OR contains(name,'Warner')) 1 1 │ │ │ FILTER id <= 2 1 1 │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'cast' 1 2 │ │ FILTER id >= 3 1 2 │ │ TABLE SCAN comp_cast_type WHERE kind >= 'complete' AND kind < 'completf' 1 1 │ FILTER id <= 2 1 1 │ TABLE SCAN company_type WHERE kind = 'production companies' 2967144 14 FILTER movie_id BETWEEN 285 AND 186175 2967144 14 FILTER IN ... 14835720 59 INNER JOIN HASH ON info = #0 0 9 │└SCAN MATERIALISED 14835720 59 TABLE SCAN movie_info WHERE info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','English')
	Estimate Actual Operator 1 1 PROJECT producing_company, link_type, complete_western_sequel 1 1 AGGREGATE MIN(name), MIN(link), MIN(title) 6313 10 DISTRIBUTE GATHER 6313 10 AGGREGATE MIN(name), MIN(link), MIN(title) 6313 743 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id 6313 743 │└DISTRIBUTE GATHER 6313 743 │ PROJECT movie_id, movie_id, name, movie_id, movie_id, movie_id, link 6313 743 │ INNER JOIN HASH ON id = link_type_id 4 2 │ │└DISTRIBUTE GATHER 4 2 │ │ FILTER link LIKE '%follow%' 18 18 │ │ DISTRIBUTE ROUND ROBIN 18 18 │ │ TABLE SCAN link_type WHERE link LIKE '%follow%' 26834 743 │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id 26834 1004 │ │└DISTRIBUTE GATHER 26834 1004 │ │ INNER JOIN HASH ON id = keyword_id 26834 1 │ │ │└DISTRIBUTE GATHER 26834 1 │ │ │ FILTER keyword = 'sequel' 134170 134170 │ │ │ DISTRIBUTE ROUND ROBIN 134170 134170 │ │ │ TABLE SCAN keyword WHERE keyword = 'sequel' 35514 727681 │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id 19830 19630 │ │ │└DISTRIBUTE GATHER 19830 19630 │ │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id 16885 20031 │ │ │ │└DISTRIBUTE GATHER 16885 20031 │ │ │ │ INNER JOIN HASH ON id = company_type_id 1 1 │ │ │ │ │└DISTRIBUTE GATHER 1 1 │ │ │ │ │ FILTER kind = 'production companies' 4 4 │ │ │ │ │ DISTRIBUTE ROUND ROBIN 4 4 │ │ │ │ │ TABLE SCAN company_type WHERE kind = 'production companies' 33771 20182 │ │ │ │ INNER JOIN HASH ON company_id = id 33771 95344 │ │ │ │ │└DISTRIBUTE GATHER 33771 95344 │ │ │ │ │ INNER JOIN HASH ON movie_id = movie_id 33771 85941 │ │ │ │ │ │└DISTRIBUTE GATHER 33771 85941 │ │ │ │ │ │ INNER JOIN HASH ON id = status_id 1 2 │ │ │ │ │ │ │└DISTRIBUTE GATHER 1 2 │ │ │ │ │ │ │ FILTER kind LIKE 'complete%' 4 4 │ │ │ │ │ │ │ DISTRIBUTE ROUND ROBIN 4 4 │ │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind LIKE 'complete%' 67543 85941 │ │ │ │ │ │ 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 122880 │ │ │ │ │ │ DISTRIBUTE ROUND ROBIN 135086 122880 │ │ │ │ │ │ TABLE SCAN complete_cast WHERE (((subject_id >= 1) AND (subject_id <= 1)) AND subject_id IN 1) AND (((status_id >= 3) AND (status_id <= 4)) AND status_id IN(3,4)) 521826 1197292 │ │ │ │ │ FILTER note IS NULL 2609129 1376261 │ │ │ │ │ TABLE SCAN movie_companies WHERE (note IS NULL AND (((movie_id >= 285) AND (movie_id <= 2528181)) AND TRUE)) AND (((company_type_id >= 2) AND (company_type_id <= 2)) AND company_type_id IN 2) 47000 48302 │ │ │ │ FILTER (country_code <> 'pl') AND (name LIKE '%Film%' OR name LIKE '%Warner%') 234997 234997 │ │ │ │ TABLE SCAN company_name WHERE ((country_code <> 'pl') AND (name LIKE '%Film%' OR name LIKE '%Warner%')) AND (((id >= 1) AND (id <= 234976)) AND TRUE) 2967144 936223 │ │ │ FILTER info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','English') 14835720 9042947 │ │ │ TABLE SCAN movie_info WHERE info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','English') AND ((((movie_id >= 8092) AND (movie_id <= 2525620)) AND ((movie_id >= 8092) AND (movie_id <= 2525620))) AND TRUE) 4523930 4523930 │ │ TABLE SCAN movie_keyword WHERE (((((movie_id >= 8322) AND (movie_id <= 2525620)) AND ((movie_id >= 8322) AND (movie_id <= 2525620))) AND ((movie_id >= 8322) AND (movie_id <= 2525620))) AND TRUE) AND (((keyword_id >= 398) AND (keyword_id <= 398)) AND keyword_id IN 398) 29997 29997 │ DISTRIBUTE ROUND ROBIN 29997 29997 │ TABLE SCAN movie_link WHERE ((((((movie_id >= 31756) AND (movie_id <= 2525069)) AND ((movie_id >= 31756) AND (movie_id <= 2525069))) AND ((movie_id >= 31756) AND (movie_id <= 2525069))) AND ((movie_id >= 31756) AND (movie_id <= 2525069))) AND TRUE) AND (((link_type_id >= 1) AND (link_type_id <= 2)) AND link_type_id IN(1,2)) 1101622 1608414 FILTER (production_year >= 1950) AND (production_year <= 2010) 2528312 2158851 TABLE SCAN title WHERE ((production_year >= 1950) AND (production_year <= 2010)) AND (((((((id >= 31756) AND (id <= 138935)) AND ((id >= 31756) AND (id <= 138935))) AND ((id >= 31756) AND (id <= 138935))) AND ((id >= 31756) AND (id <= 138935))) AND ((id >= 31756) AND (id <= 138935))) AND struct(id,id,id,id,id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr ...
	Estimate Actual Operator 1 1 AGGREGATE MIN(cn.name), MIN(lt.link), MIN(t.title) 1 1 DISTRIBUTE GATHER 1 1 AGGREGATE MIN(cn.name), MIN(lt.link), MIN(t.title) 1310 743 INNER JOIN HASH ON t.id = mi.movie_id 1310 936223 │└DISTRIBUTE GATHER 4520000 936223 │ TABLE SCAN movie_info WHERE mi.info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','English') 1310 172 INNER JOIN HASH ON ml.link_type_id = lt.id 1310 2 │└DISTRIBUTE GATHER 134000 2 │ TABLE SCAN link_type WHERE contains(lt.link,'follow') 1310 172 INNER JOIN HASH ON cc.movie_id = ml.movie_id 1310 29997 │└DISTRIBUTE GATHER 135000 29997 │ TABLE SCAN movie_link 294 664 INNER JOIN HASH ON mc.company_id = cn.id 294 2935 │└DISTRIBUTE GATHER 284 2935 │ INNER JOIN HASH ON mc.company_type_id = ct.id 284 1 │ │└DISTRIBUTE GATHER 4 1 │ │ TABLE SCAN company_type WHERE ct.kind = 'production companies' 284 2935 │ INNER JOIN HASH ON cc.movie_id = mc.movie_id 284 1791 │ │└DISTRIBUTE GATHER 111 1791 │ │ INNER JOIN HASH ON cc.movie_id = t.id 111 2225 │ │ │└DISTRIBUTE GATHER 105 2225 │ │ │ INNER JOIN HASH ON cc.subject_id = cct1.id 105 1 │ │ │ │└DISTRIBUTE GATHER 4 1 │ │ │ │ TABLE SCAN comp_cast_type WHERE cct1.kind = 'cast' 105 3266 │ │ │ INNER JOIN HASH ON cc.status_id = cct2.id 105 2 │ │ │ │└DISTRIBUTE GATHER 30000 2 │ │ │ │ TABLE SCAN comp_cast_type WHERE startswith(cct2.kind,'complete') 105 3266 │ │ │ INNER JOIN HASH ON mk.movie_id = cc.movie_id 105 10544 │ │ │ │└DISTRIBUTE GATHER 71 10544 │ │ │ │ INNER JOIN HASH ON mk.keyword_id = k.id 71 1 │ │ │ │ │└DISTRIBUTE GATHER 14800000 1 │ │ │ │ │ TABLE SCAN keyword WHERE k.keyword = 'sequel' 18 4519836 │ │ │ │ TABLE SCAN movie_keyword 235000 131098 │ │ │ TABLE SCAN complete_cast WHERE cc.movie_id IS NOT NULL 2610000 1891549 │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year >= 1950L) AND (t.production_year <= 2010L) 2530000 1186618 │ TABLE SCAN movie_companies WHERE mc.note IS NULL 4 47526 TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND ( NOT (cn.country_code = 'pl')) AND (contains(cn.name,'Film') OR contains(cn.name,'Warner'))
	Estimate Actual Operator 1 1 AGGREGATE MIN(name as name) AS Expr1024, MIN(link as link) AS Expr1025, MIN(title as title) AS Expr1026 3 743 INNER JOIN LOOP ON Bmk1022 = Bmk1022 0 743 │└TABLE SEEK title AS t WHERE production_year as production_year >= 1950 AND production_year as production_year <= 2010 7 743 PROJECT BmkToPage Bmk1022 AS Expr1100 7 743 INNER JOIN LOOP ON ml.movie_id = t.id 1 743 │└TABLE SEEK title AS t 7 743 FILTER (name as name LIKE '%Film%' OR name as name LIKE '%Warner%') AND country_code as country_code <> 'pl' 7 1808 INNER JOIN LOOP ON Bmk1006 = Bmk1006 1 1808 │└TABLE SEEK company_name AS cn 7 1808 INNER JOIN LOOP ON mc.company_id = cn.id 1 1808 │└TABLE SEEK company_name AS cn 7 1808 FILTER kind as kind = 'production companies' 15 1913 INNER JOIN LOOP ON Bmk1008 = Bmk1008 1 1913 │└TABLE SEEK company_type AS ct 15 1913 INNER JOIN LOOP ON mc.company_type_id = ct.id 1 1913 │└TABLE SEEK company_type AS ct 15 1913 FILTER note as note IS NULL 32 2253 INNER JOIN LOOP ON Bmk1014 = Bmk1014 1 2253 │└TABLE SEEK movie_companies AS mc 32 2253 PROJECT BmkToPage Bmk1014 AS Expr1098 32 2253 INNER JOIN LOOP ON ml.movie_id = mc.movie_id 9 2253 │└TABLE SEEK movie_companies AS mc 3 251 INNER JOIN LOOP ON ml.movie_id = mi.movie_id 3 251 │└TABLE SEEK movie_info AS mi WHERE info as info = 'Denish' OR info as info = 'Denmark' OR info as info = 'English' OR info as info = 'German' OR info as info = 'Germany' OR info as info = 'Norway' OR info as info = 'Norwegian' OR info as info = 'Sweden' OR info as info = 'Swedish' 1 78 FILTER kind as kind LIKE 'complete%' 1 78 INNER JOIN LOOP ON Bmk1004 = Bmk1004 1 78 │└TABLE SEEK comp_cast_type AS cct2 1 78 INNER JOIN LOOP ON cc.status_id = cct2.id 1 78 │└TABLE SEEK comp_cast_type AS cct2 1 78 FILTER kind as kind = 'cast' 1 98 INNER JOIN LOOP ON Bmk1002 = Bmk1002 1 98 │└TABLE SEEK comp_cast_type AS cct1 1 98 INNER JOIN LOOP ON cc.subject_id = cct1.id 1 98 │└TABLE SEEK comp_cast_type AS cct1 1 98 INNER JOIN LOOP ON Bmk1000 = Bmk1000 1 98 │└TABLE SEEK complete_cast AS cc 1 98 INNER JOIN LOOP ON ml.movie_id = cc.movie_id 1 98 │└TABLE SEEK complete_cast AS cc 1 199 FILTER link as link LIKE '%follow%' 7 251 INNER JOIN LOOP ON Bmk1012 = Bmk1012 1 251 │└TABLE SEEK link_type AS lt 7 251 INNER JOIN LOOP ON ml.link_type_id = lt.id 1 251 │└TABLE SEEK link_type AS lt 7 251 INNER JOIN HASH ON ml.movie_id = mk.movie_id 90 10544 │└INNER JOIN LOOP ON Bmk1018 = Bmk1018 1 10544 │ │└TABLE SEEK movie_keyword AS mk 90 10544 │ INNER JOIN LOOP ON k.id = mk.keyword_id 90 10544 │ │└TABLE SEEK movie_keyword AS mk 1 1 │ TABLE SCAN keyword AS k WHERE keyword as keyword = 'sequel' 2 250 TABLE SEEK movie_link AS ml WHERE BLOOM(movie_id as movie_id)
	Estimate Actual Operator 1 ∞ PROJECT min AS producing_company, min_54 AS link_type, min_55 AS complete_western_sequel 1 1 AGGREGATE MIN(min_56) AS min, MIN(min_57) AS min_54, MIN(min_58) AS min_55 - 16 DISTRIBUTE GATHER - 16 AGGREGATE MIN(name) AS min_56, MIN(link) AS min_57, MIN(title) AS min_58 - 743 INNER JOIN HASH ON movie_id = id_47 1060238 1900368 │└DISTRIBUTE HASH ON id_47 1060238 1900368 │ PROJECT id AS id_47, title 1060238 1900368 │ FILTER production_year BETWEEN 1950 AND 2010 1060238 1900368 │ TABLE SCAN title - 743 INNER JOIN HASH ON link_type_id = id_22 18 2 │└DISTRIBUTE GATHER 18 2 │ PROJECT id AS id_22, link 18 2 │ FILTER link LIKE '%follow%' 18 2 │ TABLE SCAN link_type - 743 INNER JOIN HASH ON movie_id = movie_id_43 29997 2315 │└DISTRIBUTE GATHER 29997 2315 │ PROJECT movie_id AS movie_id_43, link_type_id 29997 2315 │ TABLE SCAN movie_link - 41 INNER JOIN HASH ON keyword_id = id_18 134170 1 │└DISTRIBUTE GATHER 134170 1 │ PROJECT id AS id_18 134170 1 │ FILTER keyword = 'sequel' 134170 1 │ TABLE SCAN keyword - 41 INNER JOIN HASH ON movie_id = movie_id_38 4523930 30 │└DISTRIBUTE HASH ON movie_id_38 4523930 30 │ PROJECT movie_id AS movie_id_38, keyword_id 4523930 30 │ TABLE SCAN movie_keyword - 41 INNER JOIN HASH ON movie_id = movie_id_32 13352148 57 │└DISTRIBUTE HASH ON movie_id_32 13352148 57 │ PROJECT movie_id AS movie_id_32 13352148 57 │ FILTER info IN('Denish','Denmark','English','German','Germany','Norway','Norwegian','Sweden','Swedish') 13352148 57 │ TABLE SCAN movie_info - 10 INNER JOIN HASH ON company_type_id = id_13 4 1 │└DISTRIBUTE GATHER 4 1 │ PROJECT id AS id_13 4 1 │ FILTER kind = 'production companies' 4 1 │ TABLE SCAN company_type - 10 INNER JOIN HASH ON company_id = id_9 94983 48302 │└DISTRIBUTE GATHER 94983 48302 │ PROJECT id AS id_9, name 94983 48302 │ FILTER (country_code <> 'pl') AND ((name LIKE '%Film%') OR (name LIKE '%Warner%')) 94983 48302 │ TABLE SCAN company_name - 10 INNER JOIN HASH ON movie_id = movie_id_27 1271989 26 │└DISTRIBUTE HASH ON movie_id_27 1271989 26 │ PROJECT movie_id AS movie_id_27, company_id, company_type_id 1271989 26 │ FILTER note IS NULL 1271989 26 │ TABLE SCAN movie_companies - 4 INNER JOIN HASH ON status_id = id_4 4 2 │└DISTRIBUTE GATHER 4 2 │ PROJECT id AS id_4 4 2 │ FILTER (kind >= 'complete') AND (kind < 'completf') AND (kind LIKE 'complete%') 4 2 │ TABLE SCAN comp_cast_type - 4 INNER JOIN HASH ON subject_id = id_0 4 1 │└DISTRIBUTE GATHER 4 1 │ PROJECT id AS id_0 4 1 │ FILTER kind = 'cast' 4 1 │ TABLE SCAN comp_cast_type 135086 5 TABLE SCAN complete_cast
	Estimate Actual Operator 1 1 AGGREGATE MIN(name), MIN(link), MIN(title) 2 743 INNER JOIN LOOP ON id = movie_id AND movie_id = id AND (movie_id = id) 3 743 │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = movie_id AND (movie_id = movie_id) 1 172 │ │└INNER JOIN LOOP ON id = subject_id 1 229 │ │ │└INNER JOIN LOOP ON id = status_id 2 229 │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = movie_id AND (movie_id = movie_id) 1 402 │ │ │ │ │└INNER JOIN LOOP ON id = company_id 1 962 │ │ │ │ │ │└INNER JOIN LOOP ON id = company_type_id 2 1021 │ │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = movie_id AND (movie_id = movie_id) 1 199 │ │ │ │ │ │ │ │└INNER JOIN LOOP ON keyword = 'sequel' AND id = link_type_id AND (id = link_type_id) 1 2 │ │ │ │ │ │ │ │ │└TABLE SCAN link_type AS lt WHERE lt.link LIKE '%follow%' 20 502 │ │ │ │ │ │ │ │ INNER JOIN LOOP ON movie_id = movie_id 68 21088 │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON keyword_id = id 2 2 │ │ │ │ │ │ │ │ │ │└TABLE SEEK keyword AS k 610 21088 │ │ │ │ │ │ │ │ │ TABLE SEEK movie_keyword AS mk 105440 21088 │ │ │ │ │ │ │ │ TABLE SEEK movie_link AS ml 398 1020 │ │ │ │ │ │ │ TABLE SEEK movie_companies AS mc WHERE mc.note IS NULL 1021 1021 │ │ │ │ │ │ TABLE SEEK company_type AS ct WHERE ct.kind = 'production companies' 962 962 │ │ │ │ │ TABLE SEEK company_name AS cn WHERE (cn.country_code <> 'pl') AND ((cn.name LIKE '%Film%') OR (cn.name LIKE '%Warner%')) 804 402 │ │ │ │ TABLE SEEK complete_cast AS cc 229 229 │ │ │ TABLE SEEK comp_cast_type AS cct2 WHERE cct2.kind LIKE 'complete%' 229 229 │ │ TABLE SEEK comp_cast_type AS cct1 WHERE cct1.kind = 'cast' 516 743 │ TABLE SEEK movie_info AS mi WHERE mi.info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','English') 743 743 TABLE SEEK title AS t WHERE (t.production_year >= 1950) AND (t.production_year <= 2010)