oceanbase

1
create table t1 (c1 int primary key, c2 int, c3 int, c4 int);
2
create index i1 on t1(c2);
3
insert into t1 values(10, 1, 1, 1), (9, 2, 2, 2), (8, 3, 3, 3), (7, 4, 4, 4);
4
select * from t1 where c2 > 0 and c2 < 5;
5
c1	c2	c3	c4
6
10	1	1	1
7
9	2	2	2
8
8	3	3	3
9
7	4	4	4
10
select * from t1 b where b.c2 > 0 and b.c2 < 5;
11
c1	c2	c3	c4
12
10	1	1	1
13
9	2	2	2
14
8	3	3	3
15
7	4	4	4
16
select /*+index(t1 i1) */ * from t1 b where b.c2 > 0 and b.c2 < 5;
17
c1	c2	c3	c4
18
10	1	1	1
19
9	2	2	2
20
8	3	3	3
21
7	4	4	4
22
select /*+index(b i1) */ * from t1 b where b.c2 > 0 and b.c2 < 5;
23
c1	c2	c3	c4
24
10	1	1	1
25
9	2	2	2
26
8	3	3	3
27
7	4	4	4
28
drop table t1;
29