-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathoutput.txt
192 lines (180 loc) · 5.06 KB
/
output.txt
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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
SELECT COUNT(*) FROM xsmall
8
-- 0.000 seconds to run the select command. Read 2 pages
TA comment#A: 3 pages is okay. Note that you can get 2 if
you make sure that (when split) the pid of
root node is always at index = 0.
SELECT * FROM xsmall WHERE key < 2500
272 'Baby Take a Bow'
1578 'G.I. Blues'
2244 'King Creole'
2342 'Last Ride, The'
-- 0.000 seconds to run the select command. Read 2 pages
TA comment: 3 is okay, see the first comment #A
SELECT COUNT(*) FROM small
50
-- 0.000 seconds to run the select command. Read 2 pages
TA comment#B:
you don't need to read "value" column because
no duplicate is allowed in this project.
Namely, count(*) == count(key)
SELECT * FROM small WHERE key > 100 AND key < 500
173 'Angel Levine, The'
175 'Angel Unchained'
272 'Baby Take a Bow'
303 'Bananas'
395 'Big Jake'
489 'Blue Hawaii'
-- 0.000 seconds to run the select command. Read 6 pages
TA comment: 7 is okay, see first comment #A
SELECT COUNT(*) FROM medium
100
-- 0.000 seconds to run the select command. Read 4 pages
TA comment: check comment #A and #B
SELECT * FROM medium WHERE key = 489
489 'Blue Hawaii'
-- 0.000 seconds to run the select command. Read 4 pages
TA comment: 5 is okay, seed comment #A
SELECT COUNT(*) FROM large
1000
-- 0.000 seconds to run the select command. Read 21 pages
TA comment: 22 is okay, see comment #A
SELECT * FROM large WHERE key > 4500
4506 'Waterworld'
4515 'Wedding Party, The'
4524 'Welcome to the Dollhouse'
4531 'Wharf Rat, The'
4546 'When Night Is Falling'
4558 'While You Were Sleeping'
4560 'White Mans Burden'
4565 'White Wolves II: Legend of the Wild'
4570 'Who Is Harry Kellerman and Why Is He Saying Those Terrible Things About Me?'
4579 'Widows Kiss'
4581 'Wigstock: The Movie'
4583 'Wild Angels, The'
4584 'Wild Bill'
4589 'Wild Ride, The'
4601 'Windrunner'
4619 'Witch Hunt'
4620 'Witchboard III: The Possession'
4621 'Witchcraft 7: Judgement Hour'
4633 'Wizards of the Demon Sword'
4637 'Wolves, The'
4657 'Wrecking Crew, The'
4660 'Wrong Woman, The'
4673 'Yao a yao yao dao waipo qiao'
4683 'Young Poisoners Handbook, The'
4700 'Zooman'
4710 'By Way of the Stars'
4727 'Sabrina, the Teenage Witch'
4732 '¡Dispara!'
4733 'la folie'
-- 0.000 seconds to run the select command. Read 15 pages
TA Comment: 16 is okay, see comment#A
SELECT * FROM large WHERE key > 4500 AND key > 0
4506 'Waterworld'
4515 'Wedding Party, The'
4524 'Welcome to the Dollhouse'
4531 'Wharf Rat, The'
4546 'When Night Is Falling'
4558 'While You Were Sleeping'
4560 'White Mans Burden'
4565 'White Wolves II: Legend of the Wild'
4570 'Who Is Harry Kellerman and Why Is He Saying Those Terrible Things About Me?'
4579 'Widows Kiss'
4581 'Wigstock: The Movie'
4583 'Wild Angels, The'
4584 'Wild Bill'
4589 'Wild Ride, The'
4601 'Windrunner'
4619 'Witch Hunt'
4620 'Witchboard III: The Possession'
4621 'Witchcraft 7: Judgement Hour'
4633 'Wizards of the Demon Sword'
4637 'Wolves, The'
4657 'Wrecking Crew, The'
4660 'Wrong Woman, The'
4673 'Yao a yao yao dao waipo qiao'
4683 'Young Poisoners Handbook, The'
4700 'Zooman'
4710 'By Way of the Stars'
4727 'Sabrina, the Teenage Witch'
4732 '¡Dispara!'
4733 'la folie'
-- 0.000 seconds to run the select command. Read 15 pages
TA comment: 16 is okay, see comment #A
SELECT COUNT(*) FROM xlarge
12278
-- 0.000 seconds to run the select command. Read 219 pages
TA comment: see comment #A , #B
SELECT * FROM xlarge WHERE key = 4240
4240 'Tommy Boy'
-- 0.000 seconds to run the select command. Read 5 pages
TA Comment: 6 is okay, see comment #A
SELECT * FROM xlarge WHERE key > 400 AND key < 500 AND key > 100 AND key < 4000000
402 'Big Squeeze, The'
403 'Big Tease, The'
405 'Bigfoot: The Unforgettable Encounter'
407 'Biker Zombies'
408 'Bikini Bistro'
409 'Bikini Drive-In'
410 'Bikini Hoe-Down'
412 'Bikini Traffic School'
413 'Billy Elliot'
415 'Billys Holiday'
416 'Billys Hollywood Screen Kiss'
418 'Bio-Dome'
420 'Bird of Prey'
421 'Birdcage, The'
422 'Birthday Girl'
423 'BitterSweet'
424 'Black and White'
425 'Black Cat Run'
427 'Black Day Blue Night'
428 'Black Dog'
430 'Black Hawk Down'
431 'Black Knight'
433 'Black Out'
435 'Black Rose of Harlem'
436 'Black Scorpion'
437 'Black Scorpion II: Aftershock'
439 'Black Sea 213'
440 'Black Sheep'
442 'Black Widow Escort'
443 'Blackjack'
444 'BlackMale'
445 'Blackout, The'
447 'Blacktop'
448 'Blackwater Trail'
450 'Blade'
452 'Blair Witch Project, The'
453 'Blast'
454 'Blast from the Past'
457 'Bless the Child'
458 'Blessed Art Thou'
459 'Blind Faith'
460 'Blind Heat'
462 'Bliss'
463 'Blonde Heaven'
464 'Blondes Have More Guns'
465 'Blood & Donuts'
467 'Blood and Wine'
468 'Blood Money'
471 'Blood of the Innocent'
472 'Blood Oranges, The'
474 'Blood, Guts, Bullets and Octane'
477 'Bloodhounds'
479 'Bloodmoon'
480 'Bloodsport 2'
481 'Bloody Murder'
484 'Blow'
485 'Blow Dry'
486 'Blowback'
489 'Blue Hawaii'
490 'Blue Juice'
491 'Blue Moon'
492 'Blue Ridge Fall'
493 'Blues Brothers 2000'
496 'Bobby G. Cant Swim'
-- 0.000 seconds to run the select command. Read 69 pages
TA comment: minor differnce such as 69~73 are okay, see comment #A