下面是我做的测试~索引是个复合索引
都是索引扫描没问题的
scott@CCDB> select * from salgrade;
GRADE LOSAL HISAL
---------- ---------- ----------
1 700 1200
2 1201 1400
3 1401 2000
4 2001 3000
5 3001 9999
scott@CCDB> select * from salgrade where 2222 between LOSAL and HISAL;
GRADE LOSAL HISAL
---------- ---------- ----------
4 2001 3000
Execution Plan
----------------------------------------------------------
Plan hash value: 3196158779
----------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------------