FilesExpand file tree

 master

/

test.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

22 lines (17 loc) · 676 Bytes

 master

/

test.sql

Copy path

Top

File metadata and controls

• Code
• Blame

22 lines (17 loc) · 676 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

LOAD xsmall FROM 'xsmall.del' WITH INDEX

SELECT COUNT(*) FROM xsmall

SELECT * FROM xsmall WHERE key < 2500

LOAD small FROM 'small.del' WITH INDEX

SELECT COUNT(*) FROM small

SELECT * FROM small WHERE key > 100 AND key < 500

LOAD medium FROM 'medium.del' WITH INDEX

SELECT COUNT(*) FROM medium

SELECT * FROM medium WHERE key = 489

LOAD large FROM 'large.del' WITH INDEX

SELECT COUNT(*) FROM large

SELECT * FROM large WHERE key > 4500

SELECT * FROM large WHERE key > 4500 AND key > 0

LOAD xlarge FROM 'xlarge.del' WITH INDEX

SELECT COUNT(*) FROM xlarge

SELECT * FROM xlarge WHERE key = 4240

SELECT * FROM xlarge WHERE key > 400 AND key < 500 AND key > 100 AND key < 4000000