1 CREATE TABLE t1
(f1 INT NOT NULL
, f2 INT DEFAULT
'10' );
2 CREATE INDEX indx1 on t1
( f1
) HASH
;
3 CREATE INDEX indx2 on t1
( f2
) HASH
;
4 INSERT INTO t1 VALUES
(131,10);
5 INSERT INTO t1 VALUES
(141,10);
6 INSERT INTO t1 VALUES
(13,41);
7 INSERT INTO t1 VALUES
(143,41);
8 INSERT INTO t1 VALUES
(153,41);
9 INSERT INTO t1 VALUES
(163,41);
10 INSERT INTO t1 VALUES
(151,10);
11 INSERT INTO t1 VALUES
(1631,10);
12 INSERT INTO t1 VALUES
(163,41);
13 INSERT INTO t1 VALUES
(13,41);
14 INSERT INTO t1 VALUES
(23,41);
15 INSERT INTO t1 VALUES
(551,10);
16 INSERT INTO t1 VALUES
(631,10);
17 INSERT INTO t1 VALUES
(43,41);
18 INSERT INTO t1 VALUES
(3,41);
19 INSERT INTO t1 VALUES
(3,41);
20 INSERT INTO t1 VALUES
(33,41);
21 INSERT INTO t1 VALUES
(31,10);
22 INSERT INTO t1 VALUES
(31,10);
23 INSERT INTO t1 VALUES
(4,41);
24 INSERT INTO t1 VALUES
(31,10);
25 INSERT INTO t1 VALUES
(31,10);
26 INSERT INTO t1 VALUES
(31,10);
27 INSERT INTO t1 VALUES
(31,10);
28 INSERT INTO t1 VALUES
(31,10);
29 INSERT INTO t1 VALUES
(41,10);
30 INSERT INTO t1 VALUES
(3,41);
31 INSERT INTO t1 VALUES
(43,41);
32 INSERT INTO t1 VALUES
(53,41);
33 INSERT INTO t1 VALUES
(63,41);
34 INSERT INTO t1 VALUES
(51,10);
35 INSERT INTO t1 VALUES
(631,10);
36 INSERT INTO t1 VALUES
(63,41);
37 INSERT INTO t1 VALUES
(3,41);
38 INSERT INTO t1 VALUES
(3,41);
39 INSERT INTO t1 VALUES
(51,10);
40 INSERT INTO t1 VALUES
(631,10);
41 INSERT INTO t1 VALUES
(3,41);
42 INSERT INTO t1 VALUES
(3,41);
43 INSERT INTO t1 VALUES
(3,41);
44 INSERT INTO t1 VALUES
(3,41);
45 INSERT INTO t1 VALUES
(31,10);
46 INSERT INTO t1 VALUES
(31,10);
47 INSERT INTO t1 VALUES
(4,41);
48 INSERT INTO t1 VALUES
(41,10);
49 INSERT INTO t1 VALUES
(3,41);
50 INSERT INTO t1 VALUES
(43,41);
51 INSERT INTO t1 VALUES
(53,41);
52 INSERT INTO t1 VALUES
(63,41);
53 INSERT INTO t1 VALUES
(51,10);
54 INSERT INTO t1 VALUES
(631,10);
55 INSERT INTO t1 VALUES
(63,41);
56 INSERT INTO t1 VALUES
(3,41);
57 INSERT INTO t1 VALUES
(3,41);
58 INSERT INTO t1 VALUES
(51,10);
59 INSERT INTO t1 VALUES
(631,10);
60 INSERT INTO t1 VALUES
(3,41);
61 INSERT INTO t1 VALUES
(3,41);
62 INSERT INTO t1 VALUES
(3,41);
63 INSERT INTO t1 VALUES
(3,41);
64 INSERT INTO t1 VALUES
(31,10);
65 INSERT INTO t1 VALUES
(31,10);
66 INSERT INTO t1 VALUES
(4,41);
67 INSERT INTO t1 VALUES
(41,10);
68 INSERT INTO t1 VALUES
(3,41);
69 INSERT INTO t1 VALUES
(43,41);
70 INSERT INTO t1 VALUES
(53,41);
71 INSERT INTO t1 VALUES
(63,41);
72 INSERT INTO t1 VALUES
(51,10);
73 INSERT INTO t1 VALUES
(631,10);
74 INSERT INTO t1 VALUES
(63,41);
75 INSERT INTO t1 VALUES
(3,41);
76 INSERT INTO t1 VALUES
(3,41);
77 INSERT INTO t1 VALUES
(51,10);
78 INSERT INTO t1 VALUES
(631,10);
79 INSERT INTO t1 VALUES
(3,41);
80 INSERT INTO t1 VALUES
(3,41);
81 INSERT INTO t1 VALUES
(3,41);
82 INSERT INTO t1 VALUES
(3,41);
83 INSERT INTO t1 VALUES
(31,10);
84 INSERT INTO t1 VALUES
(31,10);
85 INSERT INTO t1 VALUES
(4,41);
86 INSERT INTO t1 VALUES
(3,41);
87 INSERT INTO t1 VALUES
(43,41);
88 INSERT INTO t1 VALUES
(53,41);
89 INSERT INTO t1 VALUES
(63,41);
90 INSERT INTO t1 VALUES
(51,10);
91 INSERT INTO t1 VALUES
(631,10);
92 INSERT INTO t1 VALUES
(63,41);
93 INSERT INTO t1 VALUES
(3,41);
94 INSERT INTO t1 VALUES
(3,41);
95 INSERT INTO t1 VALUES
(51,10);
96 INSERT INTO t1 VALUES
(6317,10);
97 INSERT INTO t1 VALUES
(3,41);
98 INSERT INTO t1 VALUES
(3,413);
99 INSERT INTO t1 VALUES
(3,431);
100 INSERT INTO t1 VALUES
(3,941);
101 INSERT INTO t1 VALUES
(631,10);
102 INSERT INTO t1 VALUES
(431,10);
103 INSERT INTO t1 VALUES
(14,41);
