oracle11g 怎么没有Index Skip Scan
oracle11g 怎么没有Index Skip Scan 是不是默认没了，有参数？？？ oracle11g 跳跃索引扫描
[解决办法]
SQL> select * from v$version;
BANNER
--------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
SQL> desc t
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME VARCHAR2(10)
SEX CHAR(2)
SQL> create index idx_t on t (sex,id);
Index created.
SQL> analyze index idx_t compute statistics;
Index analyzed.
SQL> set autot trace exp
SQL> select /*+ index_ss(t) */ id from t where id=8;
Execution Plan
----------------------
Plan hash value: 1727616455
--------------------------------------
[解决办法]
Id
[解决办法]
Operation
[解决办法]
Name
[解决办法]
Rows
[解决办法]
Bytes
[解决办法]
Cost (%CPU)
[解决办法]
Time
[解决办法]
--------------------------------------
[解决办法]
0
[解决办法]
SELECT STATEMENT
[解决办法]
[解决办法]
1
[解决办法]
13
[解决办法]
4 (0)
[解决办法]
00:00:01
[解决办法]
[解决办法]
* 1
[解决办法]
INDEX SKIP SCAN
[解决办法]
IDX_T
[解决办法]
1
[解决办法]
13
[解决办法]
4 (0)
[解决办法]
00:00:01
[解决办法]
--------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("ID"=8)
filter("ID"=8)
Note
-----
- dynamic sampling used for this statement
