oracle 索引快速全扫描,索引全扫描和索引快速全扫描谁效率高点

刚才去找了调优那本书，然后测试了下，发现结果好像反了。

SQL> explain plan for

2  SELECT /*+ index(t t_n1_i) */ n1 FROM t WHERE n1 IS NOT NULL ORDER BY n1;

Explained.

SQL> select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT

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

Plan hash value: 1041622781

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

| Id  | Operation        | Name   | Rows  | Bytes | Cost (%CPU)| Time     |

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

|   0 | SELECT STATEMENT |        | 10000 | 40000 |    22   (0)| 00:00:01 |

|*  1 |  INDEX FULL SCAN | T_N1_I | 10000 | 40000 |    22   (0)| 00:00:01 |

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

Predicate Information (identified by operation id):

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

PLAN_TABLE_OUTPUT

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

1 - filter("N1" IS NOT NULL)

13 rows selected.

SQL>  explain plan for

2  SELECT /*+ index_ffs(t t_n1_i) */ n1 FROM t WHERE n1 IS NOT NULL ORDER BY n1;

Explained.

SQL>  select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT

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

Plan hash value: 3958789139

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

| Id  | Operation             | Name   | Rows  | Bytes | Cost (%CPU)| Time     |

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

|   0 | SELECT STATEMENT      |        | 10000 | 40000 |     8  (25)| 00:00:01 |

|   1 |  SORT ORDER BY        |        | 10000 | 40000 |     8  (25)| 00:00:01 |

|*  2 |   INDEX FAST FULL SCAN| T_N1_I | 10000 | 40000 |     6   (0)| 00:00:01 |

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

Predicate Information (identified by operation id):

PLAN_TABLE_OUTPUT

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

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

2 - filter("N1" IS NOT NULL)

14 rows selected.