select /*+index(t index_a)*/* from t where a>0 或者
select * from t where a>0 order by a
|
a |
b |
|
3 |
10 |
|
5 |
8 |
|
11 |
2 |
|
19 |
43 |
|
21 |
1 |
select /*+index(t index_a)*/* from t where a>0 或者
select * from t where a>0 order by a
|
a |
b |
|
3 |
10 |
|
5 |
8 |
|
11 |
2 |
|
19 |
43 |
|
21 |
1 |