3 Statement Executed
: Rows Affected
= 1
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
7 Statement Executed
: Rows Affected
= 1
8 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 echo select count
(f1
) from t1
;
11 ---------------------------------------------------------
13 ---------------------------------------------------------
16 echo select * from t1 where f1
=1 and f2
=1;
17 ---------------------------------------------------------
19 ---------------------------------------------------------
23 echo select * from t1 where f1
=5 and f2
=1;
24 ---------------------------------------------------------
26 ---------------------------------------------------------
28 echo select * from t1 where f1
=5;
29 ---------------------------------------------------------
31 ---------------------------------------------------------
34 echo select * from t1 where f1
=7;
35 ---------------------------------------------------------
37 ---------------------------------------------------------
39 echo select * from t1 where f1
=10 and f2
=2 and f3
=10;
40 ---------------------------------------------------------
42 ---------------------------------------------------------
45 echo select * from t1 where f1
=10 and f2
=6 and f3
=10;
46 ---------------------------------------------------------
48 ---------------------------------------------------------
50 CREATE TABLE t1
(f1 INT NOT NULL
, f2 INT NOT NULL
, f3 INT
);
51 CREATE INDEX idx on t1
( f1
,f2
) HASH
;
52 INSERT INTO t1 VALUES
(1,1,1);
53 INSERT INTO t1 VALUES
(2,1,2);
54 INSERT INTO t1 VALUES
(3,1,3);
55 INSERT INTO t1 VALUES
(1,1,3);
56 INSERT INTO t1 VALUES
(5,2,5);
57 INSERT INTO t1 VALUES
(10,2,10);
58 INSERT INTO t1 VALUES
(100,3,100);