oracle条件与组合索引,ORACLE 组合索引 使用分析

Execution Plan

----------------------------------------------------------

0      SELECT STATEMENT ptimizer=ALL_ROWS (Cost=4 Card=1 Bytes=43)

1    0   TABLE ACCESS (BY INDEX ROWID) OF 'ZH' (TABLE) (Cost=4 Card

2    1     INDEX (RANGE SCAN) OF 'ZHIN' (INDEX) (Cost=3 Card=1)

Statistics

----------------------------------------------------------

0  recursive calls

0  db block gets

0  consistent gets

0  physical reads

0  redo size

0  bytes sent via SQL*Net to client

0  bytes received via SQL*Net from client

0  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

1  rows processed

SQL> L

1  SELECT * FROM ZH

2* WHERE IT=3

SQL> L2

2* WHERE IT=3

SQL> C/IT=3/NAME='GAOJING'

2* WHERE NAME='GAOJING'

SQL> R

1  SELECT * FROM ZH

2* WHERE NAME='GAOJING'

IT NAME                                   ID

---------- ------------------------------ ----------

3 GAOJING                               444

Execution Plan

----------------------------------------------------------

0      SELECT STATEMENT ptimizer=ALL_ROWS (Cost=201 Card=10 Bytes=

1    0   TABLE ACCESS (FULL) OF 'ZH' (TABLE) (Cost=201 Card=10 Byte

SQL> select * from zh

2  where it=3 and name='GAOJING';

IT NAME                                   ID

---------- ------------------------------ ----------

3 GAOJING                               444

Execution Plan

----------------------------------------------------------

0      SELECT STATEMENT ptimizer=ALL_ROWS (Cost=4 Card=1 Bytes=43)

1    0   TABLE ACCESS (BY INDEX ROWID) OF 'ZH' (TABLE) (Cost=4 Card

2    1     INDEX (RANGE SCAN) OF 'ZHIN' (INDEX) (Cost=3 Card=1)

Statistics

----------------------------------------------------------

0  recursive calls

0  db block gets

0  consistent gets

0  physical reads

0  redo size

0  bytes sent via SQL*Net to client

0  bytes received via SQL*Net from client

0  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

1  rows processed

Statistics

----------------------------------------------------------

0  recursive calls

0  db block gets

0  consistent gets

0  physical reads

0  redo size

0  bytes sent via SQL*Net to client

0  bytes received via SQL*Net from client

0  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

1  rows processed

试验证明结果确实如此