Planner — IMDB — JOB-22D

SELECT MIN(cn.name) AS movie_company,
       MIN(mi_idx.info) AS rating,
       MIN(t.title) AS western_violent_movie
FROM job.company_name AS cn,
     job.company_type AS ct,
     job.info_type AS it1,
     job.info_type AS it2,
     job.keyword AS k,
     job.kind_type AS kt,
     job.movie_companies AS mc,
     job.movie_info AS mi,
     job.movie_info_idx AS mi_idx,
     job.movie_keyword AS mk,
     job.title AS t
WHERE cn.country_code != '[us]'
  AND it1.info = 'countries'
  AND it2.info = 'rating'
  AND k.keyword IN ('murder',
                    'murder-in-title',
                    'blood',
                    'violence')
  AND kt.kind IN ('movie',
                  'episode')
  AND mi.info IN ('Sweden',
                  'Norway',
                  'Germany',
                  'Denmark',
                  'Swedish',
                  'Danish',
                  'Norwegian',
                  'German',
                  'USA',
                  'American')
  AND mi_idx.info < '8.5'
  AND t.production_year > 2005
  AND kt.id = t.kind_id
  AND t.id = mi.movie_id
  AND t.id = mk.movie_id
  AND t.id = mi_idx.movie_id
  AND t.id = mc.movie_id
  AND mk.movie_id = mi.movie_id
  AND mk.movie_id = mi_idx.movie_id
  AND mk.movie_id = mc.movie_id
  AND mi.movie_id = mi_idx.movie_id
  AND mi.movie_id = mc.movie_id
  AND mc.movie_id = mi_idx.movie_id
  AND k.id = mk.keyword_id
  AND it1.id = mi.info_type_id
  AND it2.id = mi_idx.info_type_id
  AND ct.id = mc.company_type_id
  AND cn.id = mc.company_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,573,297 4.6M Rank		Estimation Error Est Err 4,807,973 4.8M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 372,973 373K Rank	Estimation Error Est Err 46,281 46K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 24,664,589 25M Rank		Estimation Error Est Err 37,828,414 38M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 19,892,620 20M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 10,292,558 10M Rank		Estimation Error Est Err 9,944,807 9.9M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 1,308,677 1.3M Rank	Estimation Error Est Err 46,282 46K Rank	Estimation Error Est Err 899,854 900K Rank
Estimation Error Est Err 12,766,635 13M Rank		Estimation Error Est Err 38,833,903 39M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 21,251,345 21M Rank	Estimation Error Est Err 46,291 46K Rank	Estimation Error Est Err 3,062,488 3.1M Rank
Estimation Error Est Err 1,470,047 1.5M Rank		Estimation Error Est Err 6,864,084 6.9M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 12,754,704 13M Rank	Estimation Error Est Err 46,281 46K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 232,473 232K Rank	Estimation Error Est Err 232,470 232K Rank	Estimation Error Est Err 294,431 294K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 304,672 305K Rank	Estimation Error Est Err 46,281 46K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 502,803 503K Rank	Estimation Error Est Err 502,799 503K Rank	Estimation Error Est Err 557,240 557K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 539,890 540K Rank	Estimation Error Est Err 46,281 46K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 1,289,840 1.3M Rank		Estimation Error Est Err 975,085 975K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 1,890,247 1.9M Rank	Estimation Error Est Err 46,297 46K Rank	Estimation Error Est Err 1,214,450 1.2M Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min, min 29 46281 INNER JOIN HASH ON id = info_type_id76 1 1 │└TABLE SCAN info_type WHERE info = rating 40 46281 INNER JOIN HASH ON movie_id57 = movie_id75 26 47475 │└INNER JOIN HASH ON id6 = company_type_id 4 4 │ │└TABLE SCAN company_type 2 47475 │ INNER JOIN HASH ON id64 = company_id 4 68049 │ │└INNER JOIN HASH ON id33 = movie_id57 4 5316 │ │ │└INNER JOIN HASH ON id11 = info_type_id 1 1 │ │ │ │└TABLE SCAN info_type WHERE info = countries 5 5833 │ │ │ INNER JOIN HASH ON id33 = movie_id49 18 8073 │ │ │ │└INNER JOIN HASH ON id16 = kind_id 2 2 │ │ │ │ │└TABLE SCAN kind_type WHERE kind17 IN(episode,movie) 56 8408 │ │ │ │ INNER JOIN HASH ON id33 = movie_id 129 37091 │ │ │ │ │└INNER JOIN HASH ON id21 = keyword_id 4 3 │ │ │ │ │ │└TABLE SCAN keyword WHERE keyword IN(blood,murder,murder - in - title,violence) 4523930 4523930 │ │ │ │ │ TABLE SCAN movie_keyword 1049348 6099 │ │ │ │ TABLE SCAN title WHERE production_year >= 2006 622984 4071 │ │ │ TABLE SCAN movie_info WHERE info BETWEEN American AND USA AND info51 IN(American,Danish,Denmark,German,Germany,Norway,Norwegian,Sweden,Swedish,USA) 2076277 34106 │ │ TABLE SCAN movie_companies 120711 3358 │ TABLE SCAN company_name WHERE country_code <> us 1342299 1722 TABLE SCAN movie_info_idx WHERE info < 8.5
	Estimate Actual Operator - 1 PROJECT a1 AS movie_company, a2 AS rating, a3 AS western_violent_movie - 1 AGGREGATE MIN(name) AS a1, MIN(info) AS a2, MIN(title) AS a3 - 0 PROJECT name, info, title - 0 PROJECT name, info, title - 0 INNER JOIN HASH ON tuple(PROJECTION_2510.movie_id,PROJECTION_2510.movie_id,PROJECTION_2510.movie_id,PROJECTION_2510.movie_id,PROJECTION_2510.movie_id,PROJECTION_2510.movie_id) = tuple(PROJECTION_2483.movie_id,PROJECTION_2483.movie_id,PROJECTION_2483.movie_id,PROJECTION_2483.id,PROJECTION_2483.id,PROJECTION_2483.id) - 818627 │└PROJECT movie_id AS movie_id_right, id, name, title - 818627 │ PROJECT name, movie_id, title, id - 818627 │ INNER JOIN HASH ON PROJECTION_2489.company_type_id = PROJECTION_2486.id - 4 │ │└PROJECT id AS id_right - 4 │ │ PROJECT id - 4 │ │ TABLE SCAN company_type - 818627 │ PROJECT company_type_id, name, movie_id, title, id_left - 818627 │ PROJECT name, company_type_id, movie_id, title, id - 818627 │ INNER JOIN HASH ON PROJECTION_2495.kind_id = PROJECTION_2492.id - 7 │ │└PROJECT id AS id_right - 7 │ │ PROJECT id - 7 │ │ TABLE SCAN kind_type WHERE TRUE - 818627 │ PROJECT kind_id, name, company_type_id, movie_id, title, id AS id_left - 818627 │ PROJECT name, company_type_id, movie_id, title, id, kind_id - 818627 │ INNER JOIN HASH ON PROJECTION_2501.movie_id = PROJECTION_2498.id - 1012920 │ │└PROJECT id, title, kind_id - 1012920 │ │ PROJECT id, title, kind_id - 1012920 │ │ TABLE SCAN title WHERE production_year > 2005 - 2497734 │ PROJECT movie_id, name, company_type_id - 2497734 │ PROJECT name, company_type_id, movie_id - 2497734 │ INNER JOIN HASH ON PROJECTION_2507.id = PROJECTION_2504.company_id - 2609129 │ │└PROJECT company_id, company_type_id, movie_id - 2609129 │ │ PROJECT company_id, company_type_id, movie_id - 2609129 │ │ TABLE SCAN movie_companies - 211073 │ PROJECT id, name - 211073 │ PROJECT id, name - 211073 │ TABLE SCAN company_name WHERE country_code <> 'us' - 4107697 PROJECT movie_id AS movie_id_left, movie_id AS movie_id_left_2, movie_id AS movie_id_left_3, info - 4107697 PROJECT movie_id, info, movie_id, movie_id - 4107697 INNER JOIN HASH ON tuple(PROJECTION_2522.movie_id,PROJECTION_2522.movie_id) = tuple(PROJECTION_2513.movie_id,PROJECTION_2513.movie_id) - 1325361 │└PROJECT movie_id AS movie_id_right - 1325361 │ PROJECT movie_id - 1325361 │ INNER JOIN HASH ON PROJECTION_2519.info_type_id = PROJECTION_2516.id - 1 │ │└PROJECT id - 1 │ │ PROJECT id - 1 │ │ TABLE SCAN info_type WHERE info = 'countries' - 14835720 │ PROJECT info_type_id, movie_id - 14835720 │ PROJECT movie_id, info_type_id - 14835720 │ TABLE SCAN movie_info WHERE TRUE - 3403472 PROJECT movie_id_left, movie_id AS movie_id_left_2, info - 3403472 PROJECT info, movie_id, movie_id - 3403472 INNER JOIN HASH ON PROJECTION_2528.keyword_id = PROJECTION_2525.id - 134170 │└PROJECT id - 134170 │ PROJECT id - 134170 │ TABLE SCAN keyword WHERE TRUE - 3403472 PROJECT keyword_id, info, movie_id, movie_id - 3403472 PROJECT info, movie_id, movie_id, keyword_id - 3403472 INNER JOIN HASH ON PROJECTION_2534.movie_id = PROJECTION_2531.movie_id - 4523930 │└PROJECT movie_id AS movie_id_right, keyword_id - 4523930 │ PROJECT movie_id, keyword_id - 4523930 │ TABLE SCAN movie_keyword - 454230 PROJECT movie_id AS movie_id_left, info - 454230 PROJECT info, movie_id - 454230 INNER JOIN HASH ON PROJECTION_2540.info_type_id = PROJECTION_2537.id - 1 │└PROJECT id - 1 │ PROJECT id - 1 │ TABLE SCAN info_type WHERE info = 'rating' - 1337634 PROJECT info_type_id, info, movie_id - 1337634 PROJECT movie_id, info, info_type_id - 1337634 TABLE SCAN movie_info_idx WHERE info < '8.5'
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1), MIN(#2) 0 46281 PROJECT name, info, title 0 46281 INNER JOIN HASH ON id = company_type_id 0 46281 │└INNER JOIN HASH ON id = keyword_id 1 5536051 │ │└INNER JOIN HASH ON movie_id = movie_id 0 99935 │ │ │└INNER JOIN HASH ON id = company_id 3 189157 │ │ │ │└INNER JOIN HASH ON movie_id = movie_id 3 44414 │ │ │ │ │└INNER JOIN HASH ON info_type_id = id 2 1 │ │ │ │ │ │└FILTER id <= 110 2 1 │ │ │ │ │ │ TABLE SCAN info_type WHERE info = 'countries' 169 44414 │ │ │ │ │ INNER JOIN HASH ON movie_id = movie_id 142 106968 │ │ │ │ │ │└INNER JOIN HASH ON kind_id = id 1 2 │ │ │ │ │ │ │└FILTER (kind = 'movie') OR (kind = 'episode') 7 7 │ │ │ │ │ │ │ TABLE SCAN kind_type WHERE kind IN('movie','episode') 994 140451 │ │ │ │ │ │ INNER JOIN HASH ON id = movie_id 4885 454222 │ │ │ │ │ │ │└INNER JOIN HASH ON info_type_id = id 2 1 │ │ │ │ │ │ │ │└FILTER id >= 99 2 1 │ │ │ │ │ │ │ │ TABLE SCAN info_type WHERE info = 'rating' 276007 454222 │ │ │ │ │ │ │ FILTER movie_id <= 2525745 276007 454230 │ │ │ │ │ │ │ TABLE SCAN movie_info_idx WHERE info < '8.5' 505662 143657 │ │ │ │ │ │ FILTER id BETWEEN 2 AND 2525745 505662 143658 │ │ │ │ │ │ TABLE SCAN title WHERE production_year > 2005 2967144 46127 │ │ │ │ │ FILTER movie_id BETWEEN 2 AND 2525745 2967144 46127 │ │ │ │ │ FILTER IN ... 14835720 91213 │ │ │ │ │ INNER JOIN HASH ON info = #0 0 10 │ │ │ │ │ │└SCAN MATERIALISED 14835720 91213 │ │ │ │ │ TABLE SCAN movie_info WHERE info IN('Sweden','Norway','Germany','Denmark','Swedish','Danish','Norwegian','German','USA','American') 2609129 182311 │ │ │ │ TABLE SCAN movie_companies 46999 126230 │ │ │ TABLE SCAN company_name WHERE country_code != 'us' 4523930 338396 │ │ TABLE SCAN movie_keyword WHERE movie_id <= 2525745 26834 3 │ FILTER (keyword = 'murder') OR (keyword = 'murder-in-title') OR (keyword = 'blood') OR (keyword = 'violence') 134170 133988 │ TABLE SCAN keyword WHERE keyword IN('murder','murder-in-title','blood','violence') 4 2 TABLE SCAN company_type WHERE id <= 2
	Estimate Actual Operator 1 1 PROJECT movie_company, rating, western_violent_movie 1 1 AGGREGATE MIN(name), MIN(info), MIN(title) 13114 10 DISTRIBUTE GATHER 13114 10 AGGREGATE MIN(name), MIN(info), MIN(title) 13114 46281 INNER JOIN HASH ON id = kind_id 2 2 │└DISTRIBUTE GATHER 2 2 │ FILTER (kind = 'movie') OR (kind = 'episode') 7 7 │ DISTRIBUTE ROUND ROBIN 7 7 │ TABLE SCAN kind_type WHERE (kind = 'movie') OR (kind = 'episode') 45899 49908 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id 45899 144733 │└DISTRIBUTE GATHER 45899 144733 │ INNER JOIN HASH ON id = keyword_id 26834 3 │ │└DISTRIBUTE GATHER 26834 3 │ │ FILTER keyword IN('murder','murder-in-title','blood','violence') 134170 134170 │ │ DISTRIBUTE ROUND ROBIN 134170 134170 │ │ TABLE SCAN keyword WHERE keyword IN('murder','murder-in-title','blood','violence') 229499 15284830 │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id 128143 302495 │ │└DISTRIBUTE GATHER 128143 302495 │ │ INNER JOIN HASH ON id = info_type_id 23 1 │ │ │└DISTRIBUTE GATHER 23 1 │ │ │ FILTER info = 'rating' 113 113 │ │ │ DISTRIBUTE ROUND ROBIN 113 113 │ │ │ TABLE SCAN info_type WHERE info = 'rating' 128143 900042 │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id 128143 396423 │ │ │└DISTRIBUTE GATHER 128143 396423 │ │ │ INNER JOIN HASH ON id = info_type_id 23 1 │ │ │ │└DISTRIBUTE GATHER 23 1 │ │ │ │ FILTER info = 'countries' 113 113 │ │ │ │ DISTRIBUTE ROUND ROBIN 113 113 │ │ │ │ TABLE SCAN info_type WHERE info = 'countries' 612861 396423 │ │ │ INNER JOIN HASH ON movie_id = movie_id 521832 1343936 │ │ │ │└DISTRIBUTE HASH ON movie_id 521832 1343936 │ │ │ │ INNER JOIN HASH ON id = company_type_id 4 4 │ │ │ │ │└TABLE SCAN company_type 521832 1343936 │ │ │ │ INNER JOIN HASH ON id = company_id 47000 126230 │ │ │ │ │└DISTRIBUTE GATHER 47000 126230 │ │ │ │ │ FILTER country_code <> 'us' 234997 234997 │ │ │ │ │ TABLE SCAN company_name WHERE country_code <> 'us' 2609129 2609129 │ │ │ │ TABLE SCAN movie_companies WHERE (((company_id >= 4) AND (company_id <= 234995)) AND TRUE) AND (((company_type_id >= 1) AND (company_type_id <= 4)) AND company_type_id IN(1,2,3,4)) 2967144 614251 │ │ │ DISTRIBUTE HASH ON movie_id 2967144 614251 │ │ │ FILTER info IN('Sweden','Norway','Germany','Denmark','Swedish','Danish','Norwegian','German','USA','American') 14835720 1355825 │ │ │ TABLE SCAN movie_info WHERE (info IN('Sweden','Norway','Germany','Denmark','Swedish','Danish','Norwegian','German','USA','American') AND CASE MOD(HASH_REPARTITION movie_id,10) WHEN 0 THEN (((movie_id >= 67) AND (movie_id <= 2525735)) AND TRUE) WHEN 1 THEN (((movie_id >= 63) AND (movie_id <= 2525641)) AND TRUE) WHEN 2 THEN (((movie_id >= 51) AND (movie_id <= 2525742)) AND TRUE) WHEN 3 THEN (((movie_id >= 11) AND (movie_id <= 2525673)) AND TRUE) WHEN 4 THEN (((mo... 276007 1337634 │ │ FILTER info < '8.5' 1380035 1380035 │ │ TABLE SCAN movie_info_idx WHERE ((info < '8.5') AND ((((movie_id >= 50) AND (movie_id <= 2525744)) AND ((movie_id >= 50) AND (movie_id <= 2525744))) AND TRUE)) AND (((info_type_id >= 101) AND (info_type_id <= 101)) AND info_type_id IN 101) 4523930 4523930 │ TABLE SCAN movie_keyword WHERE (((((movie_id >= 50) AND (movie_id <= 2525663)) AND ((movie_id >= 50) AND (movie_id <= 2525663))) AND ((movie_id >= 50) AND (movie_id <= 2525663))) AND TRUE) AND (((keyword_id >= 137) AND (keyword_id <= 875)) AND keyword_id IN(875,865,137)) 252832 1012920 FILTER production_year > 2005 2528312 2528312 TABLE SCAN title WHERE ((production_year > 2005) AND ((((((id >= 581) AND (id <= 2525471)) AND ((id >= 581) AND (id <= 2525471))) AND ((id >= 581) AND (id <= 2525471))) AND ((id >= 581) AND (id <= 2525471))) AND TRUE)) AND (((kind_id >= 1) AND (kind_id <= 7)) AND kind_id IN(1,7))
	Estimate Actual Operator 1 1 AGGREGATE MIN(cn.name), MIN(mi_idx.info), MIN(t.title) 1 1 DISTRIBUTE GATHER 1 1 AGGREGATE MIN(cn.name), MIN(mi_idx.info), MIN(t.title) 1530 46281 INNER JOIN HASH ON mi.info_type_id = it1.id 1530 1 │└DISTRIBUTE GATHER 4520000 1 │ TABLE SCAN info_type WHERE it1.info = 'countries' 1530 54578 INNER JOIN HASH ON mc.movie_id = mi.movie_id 1530 716210 │└DISTRIBUTE GATHER 134000 716210 │ TABLE SCAN movie_info WHERE mi.info IN('Sweden','Norway','Germany','Denmark','Swedish','Danish','Norwegian','German','USA','American') 1530 56448 INNER JOIN HASH ON mi_idx.info_type_id = it2.id 1530 1 │└DISTRIBUTE GATHER 7 1 │ TABLE SCAN info_type WHERE it2.info = 'rating' 1530 167828 INNER JOIN HASH ON mc.movie_id = mi_idx.movie_id 1530 58583 │└DISTRIBUTE GATHER 492 58583 │ INNER JOIN HASH ON mc.company_id = cn.id 492 79885 │ │└DISTRIBUTE GATHER 476 79885 │ │ INNER JOIN HASH ON mc.company_type_id = ct.id 476 4 │ │ │└DISTRIBUTE GATHER 4 4 │ │ │ TABLE SCAN company_type 476 79885 │ │ INNER JOIN HASH ON mk.movie_id = mc.movie_id 476 8073 │ │ │└DISTRIBUTE GATHER 186 8073 │ │ │ INNER JOIN HASH ON t.kind_id = kt.id 186 2 │ │ │ │└DISTRIBUTE GATHER 1380000 2 │ │ │ │ TABLE SCAN kind_type WHERE kt.kind IN('movie','episode') 186 9731 │ │ │ INNER JOIN HASH ON mk.movie_id = t.id 186 37091 │ │ │ │└DISTRIBUTE GATHER 176 37091 │ │ │ │ INNER JOIN HASH ON mk.keyword_id = k.id 176 3 │ │ │ │ │└DISTRIBUTE GATHER 113 3 │ │ │ │ │ TABLE SCAN keyword WHERE k.keyword IN('murder','murder-in-title','blood','violence') 14800000 4519843 │ │ │ │ TABLE SCAN movie_keyword 113 1009646 │ │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year > 2005L) 235000 2600943 │ │ TABLE SCAN movie_companies 2610000 124204 │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND ( NOT (cn.country_code = 'us')) 2530000 1321701 TABLE SCAN movie_info_idx WHERE mi_idx.info < '8.5'
	Estimate Actual Operator 1 1 AGGREGATE MIN(name as name) AS Expr1022, MIN(info as info) AS Expr1023, MIN(title as title) AS Expr1024 4 46281 FILTER country_code as country_code <> 'us' 9 64848 INNER JOIN LOOP ON Bmk1000 = Bmk1000 1 64848 │└TABLE SEEK company_name AS cn 9 64848 INNER JOIN LOOP ON mc.company_id = cn.id 1 64848 │└TABLE SEEK company_name AS cn 9 64848 INNER JOIN LOOP ON Bmk1012 = Bmk1012 1 64848 │└TABLE SEEK movie_companies AS mc 9 64848 PROJECT BmkToPage Bmk1012 AS Expr1285 9 64848 INNER JOIN LOOP ON t.id = mc.movie_id 9 64848 │└TABLE SEEK movie_companies AS mc 1 4115 FILTER info as info = 'rating' 4 12339 INNER JOIN LOOP ON Bmk1006 = Bmk1006 1 12339 │└TABLE SEEK info_type AS it2 4 12339 INNER JOIN LOOP ON mi_idx.info_type_id = it2.id 1 12339 │└TABLE SEEK info_type AS it2 4 12339 INNER JOIN LOOP ON t.id = mi_idx.movie_id 2 12339 │└TABLE SEEK movie_info_idx AS mi_idx WHERE info as info < '8.5' 1 5316 FILTER kind as kind = 'episode' OR kind as kind = 'movie' 5 6566 INNER JOIN LOOP ON Bmk1010 = Bmk1010 1 6566 │└TABLE SEEK kind_type AS kt 5 6566 INNER JOIN LOOP ON t.kind_id = kt.id 1 6566 │└TABLE SEEK kind_type AS kt 5 6566 INNER JOIN LOOP ON Bmk1020 = Bmk1020 0 6566 │└TABLE SEEK title AS t WHERE production_year as production_year > 2005 14 23916 PROJECT BmkToPage Bmk1020 AS Expr1284 14 23916 INNER JOIN LOOP ON mk.movie_id = t.id 1 23916 │└TABLE SEEK title AS t 14 23916 FILTER info as info = 'American' OR info as info = 'Danish' OR info as info = 'Denmark' 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' OR info as info = 'USA' 308 44297 INNER JOIN LOOP ON mi.movie_id = mi.movie_id AND Uniq1015 = Uniq1015 1 44297 │└TABLE SEEK movie_info AS mi 308 44297 INNER JOIN LOOP ON it1.id = mi.info_type_id AND mk.movie_id = mi.movie_id 1 44297 │└TABLE SEEK movie_info AS mi 362 37091 INNER JOIN LOOP ON info as info = 'countries' 1 1 │└MATERIALISE AS m38 1 1 │ TABLE SCAN info_type AS it1 WHERE info as info = 'countries' 362 37091 INNER JOIN LOOP ON Bmk1018 = Bmk1018 1 37091 │└TABLE SEEK movie_keyword AS mk 362 37091 INNER JOIN LOOP ON k.id = mk.keyword_id 90 37091 │└TABLE SEEK movie_keyword AS mk 4 3 TABLE SCAN keyword AS k WHERE keyword as keyword = 'blood' OR keyword as keyword = 'murder' OR keyword as keyword = 'murder-in-title' OR keyword as keyword = 'violence'
	Estimate Actual Operator 1 ∞ PROJECT min AS movie_company, min_53 AS rating, min_54 AS western_violent_movie 1 1 AGGREGATE MIN(min_55) AS min, MIN(min_56) AS min_53, MIN(min_57) AS min_54 - 16 DISTRIBUTE GATHER - 16 AGGREGATE MIN(name) AS min_55, MIN(info_36) AS min_56, MIN(title) AS min_57 - 46281 INNER JOIN HASH ON kind_id = id_17 7 2 │└DISTRIBUTE GATHER 7 2 │ PROJECT id AS id_17 7 2 │ FILTER kind IN('episode','movie') 7 2 │ TABLE SCAN kind_type - 49898 INNER JOIN HASH ON movie_id = id_46 247389 1012688 │└DISTRIBUTE HASH ON id_46 247389 1012688 │ PROJECT id AS id_46, title, kind_id 247389 1012688 │ FILTER production_year > 2005 247389 1012688 │ TABLE SCAN title - 144733 INNER JOIN HASH ON keyword_id = id_13 134170 3 │└DISTRIBUTE GATHER 134170 3 │ PROJECT id AS id_13 134170 3 │ FILTER keyword IN('blood','murder','murder-in-title','violence') 134170 3 │ TABLE SCAN keyword - 144733 INNER JOIN HASH ON movie_id = movie_id_42 4523930 37091 │└DISTRIBUTE HASH ON movie_id_42 4523930 37091 │ PROJECT movie_id AS movie_id_42, keyword_id 4523930 37091 │ TABLE SCAN movie_keyword - 85044 INNER JOIN HASH ON info_type_id_35 = id_8 113 1 │└DISTRIBUTE GATHER 113 1 │ PROJECT id AS id_8 113 1 │ FILTER info = 'rating' 113 1 │ TABLE SCAN info_type - 85044 INNER JOIN HASH ON movie_id = movie_id_34 1380035 23199 │└DISTRIBUTE HASH ON movie_id_34 1380035 23199 │ PROJECT movie_id AS movie_id_34, info_type_id AS info_type_id_35, info AS info_36 1380035 23199 │ FILTER info < '8.5' 1380035 23199 │ TABLE SCAN movie_info_idx - 85044 INNER JOIN HASH ON info_type_id = id_4 113 1 │└DISTRIBUTE GATHER 113 1 │ PROJECT id AS id_4 113 1 │ FILTER info = 'countries' 113 1 │ TABLE SCAN info_type - 85044 INNER JOIN HASH ON movie_id = movie_id_27 13352148 15215 │└DISTRIBUTE HASH ON movie_id_27 13352148 15215 │ PROJECT movie_id AS movie_id_27, info_type_id 13352148 15215 │ FILTER info IN('American','Danish','Denmark','German','Germany','Norway','Norwegian','Sweden','Swedish','USA') 13352148 15215 │ TABLE SCAN movie_info - 75406 INNER JOIN HASH ON company_type_id = id_0 4 4 │└DISTRIBUTE GATHER 4 4 │ PROJECT id AS id_0 4 4 │ TABLE SCAN company_type - 75406 INNER JOIN HASH ON company_id = id 105537 126230 │└DISTRIBUTE GATHER 105537 126230 │ FILTER country_code <> 'us' 105537 126230 │ TABLE SCAN company_name 2609129 75406 TABLE SCAN movie_companies
	Estimate Actual Operator 1 1 AGGREGATE MIN(name), MIN(info), MIN(title) 1 46281 INNER JOIN LOOP ON id = company_type_id AND (id = company_type_id) 1 46281 │└INNER JOIN LOOP ON id = company_id 1 64848 │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 4115 │ │ │└INNER JOIN LOOP ON id = info_type_id 1 4709 │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 5949 │ │ │ │ │└INNER JOIN LOOP ON id = info_type_id 43 17891 │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 15 8073 │ │ │ │ │ │ │└INNER JOIN HASH ON kind_id = id 2 2 │ │ │ │ │ │ │ │└TABLE SCAN kind_type AS kt WHERE kt.kind IN('movie','episode') 53 9739 │ │ │ │ │ │ │ INNER JOIN LOOP ON id = movie_id 135 37091 │ │ │ │ │ │ │ │└INNER JOIN LOOP ON keyword_id = id 4 3 │ │ │ │ │ │ │ │ │└TABLE SEEK keyword AS k 915 37091 │ │ │ │ │ │ │ │ TABLE SEEK movie_keyword AS mk 37091 37091 │ │ │ │ │ │ │ TABLE SEEK title AS t WHERE t.production_year > 2005 24219 17922 │ │ │ │ │ │ TABLE SEEK movie_info_idx AS mi_idx WHERE mi_idx.info < '8.5' 5 5 │ │ │ │ │ TABLE SEEK info_type AS it2 WHERE it2.info = 'rating' 11898 5949 │ │ │ │ TABLE SEEK movie_info AS mi WHERE mi.info IN('Sweden','Norway','Germany','Denmark','Swedish','Danish','Norwegian','German','USA','American') 4709 4709 │ │ │ TABLE SEEK info_type AS it1 WHERE it1.info = 'countries' 20575 64852 │ │ TABLE SEEK movie_companies AS mc 64848 64848 │ TABLE SEEK company_name AS cn WHERE cn.country_code <> 'us' 4 1 TABLE SCAN company_type AS ct