_table_scan_cost_plus_one

根据群聊记录整理

SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
  FROM x$ksppi x, x$ksppcv y
 WHERE x.inst_id = USERENV ('Instance')
   AND y.inst_id = USERENV ('Instance')
   AND x.indx = y.indx
   AND x.ksppinm LIKE '%_table_scan_cost_plus_one%';


NAME				  VALUE
-------------------------------------- 
_table_scan_cost_plus_one	  TRUE



select count(*) from test;

Execution Plan
----------------------------------------------------------
Plan hash value: 1950795681

-------------------------------------------------------------------
| Id  | Operation	   | Name | Rows  | Cost (%CPU)| Time	  |
-------------------------------------------------------------------
|   0 | SELECT STATEMENT   |	  |	1 |   222   (1)| 00:00:01 |
|   1 |  SORT AGGREGATE    |	  |	1 |	       |	  |
|   2 |   TABLE ACCESS FULL| TEST |  1000 |   222   (1)| 00:00:01 |
-------------------------------------------------------------------

SQL> alter session set "_table_scan_cost_plus_one"=false;

Session altered.

select count(*) from test;


Execution Plan
----------------------------------------------------------
Plan hash value: 1950795681

-------------------------------------------------------------------
| Id  | Operation	   | Name | Rows  | Cost (%CPU)| Time	  |
-------------------------------------------------------------------
|   0 | SELECT STATEMENT   |	  |	1 |   221   (1)| 00:00:01 |
|   1 |  SORT AGGREGATE    |	  |	1 |	       |	  |
|   2 |   TABLE ACCESS FULL| TEST |  1000 |   221   (1)| 00:00:01 |
-------------------------------------------------------------------