利用函数索引优化<>

SQL> select count(*),ID from test_2 group by id;

  COUNT(*)	   ID
---------- ----------
    131072	    1
   1179648	    2

select count(*) from test_2 where id <>2;------利用函数索引优化:

select count(*) from test_2 where id <>2;SQL> 


SQL> select count(*) from test_2 where id <>2;


Execution Plan
----------------------------------------------------------
Plan hash value: 1548797762

-----------------------------------------------------------------------------
| Id  | Operation	   | Name   | Rows  | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |	    |	  1 |	  3 |	801   (6)| 00:00:10 |
|   1 |  SORT AGGREGATE    |	    |	  1 |	  3 |		 |	    |
|*  2 |   TABLE ACCESS FULL| TEST_2 |	655K|  1920K|	801   (6)| 00:00:10 |
-----------------------------------------------------------------------------

Predicate Information (i