CS121-Mini-Search-Engine/Tokens.sql at master · Jeremyyang920/CS121-Mini-Search-Engine · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
-- SET GLOBAL max_allowed_packet = 1073741824;

-- DROP TABLE `Tokens`;

-- CREATE TABLE `Tokens` (
-- 	`token` VARCHAR(1000),
--  `document` TEXT(20000000)
-- );

-- SELECT COUNT(*) FROM TOKENS;

-- OPTIMIZE TABLE `Tokens`;
-- CREATE INDEX `token_index` ON `Tokens`(`token`) USING BTREE;
-- SELECT * FROM `Tokens` WHERE token = 'anuj';

-- DROP TABLE `H1`;

-- CREATE TABLE `H1` (
-- 	`token` VARCHAR(1000),
--  `document` TEXT(20000000)
-- );

SELECT COUNT(*) FROM H1;

-- OPTIMIZE TABLE `H1`;
-- CREATE INDEX `h1_index` ON `H1`(`token`) USING BTREE;

-- DROP TABLE `H2`;

-- CREATE TABLE `H2` (
-- 	`token` VARCHAR(1000),
--  `document` TEXT(20000000)
-- );

SELECT COUNT(*) FROM H2;

-- OPTIMIZE TABLE `H2`;
-- CREATE INDEX `h2_index` ON `H1`(`token`) USING BTREE;

-- DROP TABLE `H3`;

-- CREATE TABLE `H3` (
-- 	`token` VARCHAR(1000),
--  `document` TEXT(20000000)
-- );

SELECT COUNT(*) FROM H3;

-- OPTIMIZE TABLE `H3`;
-- CREATE INDEX `h3_index` ON `H3`(`token`) USING BTREE;

-- DROP TABLE `B`;

-- CREATE TABLE `B` (
--  `token` VARCHAR(1000),
--  `document` TEXT(20000000)
-- );

SELECT COUNT(*) FROM B;

-- OPTIMIZE TABLE `B`;
-- CREATE INDEX `b_index` ON `B`(`token`) USING BTREE;