forked from winkyao/join-order-benchmark
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathallcount.sql
More file actions
21 lines (21 loc) · 926 Bytes
/
allcount.sql
File metadata and controls
21 lines (21 loc) · 926 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
select count(*) aka_name from aka_name;
select count(*) aka_title from aka_title;
select count(*) cast_info from cast_info;
select count(*) char_name from char_name;
select count(*) company_name from company_name;
select count(*) company_type from company_type;
select count(*) comp_cast_type from comp_cast_type;
select count(*) complete_cast from complete_cast;
select count(*) info_type from info_type;
select count(*) keyword from keyword;
select count(*) kind_type from kind_type;
select count(*) link_type from link_type;
select count(*) movie_companies from movie_companies;
select count(*) movie_info from movie_info;
select count(*) movie_info_idx from movie_info_idx;
select count(*) movie_keyword from movie_keyword;
select count(*) movie_link from movie_link;
select count(*) name from name;
select count(*) person_info from person_info;
select count(*) role_type from role_type;
select count(*) title from title;