10g索引的作用实验1

关注

原创最新推荐文章于 2026-09-20 10:56:54 发布 459 阅读 AI 写同款· GEO 优化 ›

TPS65131实战：单电源如何稳定输出正负双电压在模拟电路与传感器系统中，运放、ADC和音频电路常需要正负双电源供电，而单电池或USB输入往往只提供一路正压。DC-DC转换技术是解决这一问题的关键，通过升压和反相Buck-Boost拓扑，可将单路输入变换为稳定的双极性输出。相比电荷泵和隔离模块，集成双路输出的开关电源芯片在纹波、体积和成本上更具优势，尤其适合便携仪表、精密数据采集及音频设备等低功耗高线性度场景。本文以实际工程设计为主线，介绍了一款典型双路输出电源芯片的选型依据、外围参数计算、PCB布局要点和带载调试方法，并重点剖析了电感饱和、负压电容极性阅读详情

1）授权SCOTT DBA权限

grant dba to scott;

2）SCOTT创建测试大表

create table tab_idx_test
as
select * from dba_objects
where owner in('PUBLIC','SCOTT','SYS','SYSTEM');

3）打开执行计划

SET AUTOTRACE TRACE EXPLAIN

4）查询指定条件数据

SQL>SELECT OWNER,OBJECT_NAME FROM TAB_IDX_TEST WHERE OBJECT_NAME='DBA_INDEXES';
Elapsed: 00:00:00.00

Execution Plan
----------------------------------------------------------
Plan hash value: 2925858188

----------------------------------------------------------------------------------
| Id    | Operation                 | Name                 | Rows    | Bytes | Cost (%CPU)| Time         |
----------------------------------------------------------------------------------
|     0 | SELECT STATEMENT    |                            |         7 |     581 |     142     (3)| 00:00:02 |
|*    1 |    TABLE ACCESS FULL| TAB_IDX_TEST |         7 |     581 |     142     (3)| 00:00:02 |
----------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

     1 - filter("OBJECT_NAME"='DBA_INDEXES')

Note
-----
     - dynamic sampling used for this statement

SQL>

5）在object_name上创建索引idx_tab_idx_test

CREATE INDEX idx_tab_idx_test
on tab_idx_test(object_name);

6）再次查询指定条件数据

SQL> SELECT OWNER,OBJECT_NAME FROM TAB_IDX_TEST WHERE OBJECT_NAME='DBA_INDEXES';
Elapsed: 00:00:00.03

Execution Plan
----------------------------------------------------------
Plan hash value: 3112998378

------------------------------------------------------------------------------------------------
| Id    | Operation                                     | Name                         | Rows    | Bytes | Cost (%CPU)| Time         |
------------------------------------------------------------------------------------------------
|     0 | SELECT STATEMENT                        |                                    |         2 |     166 |         2     (0)| 00:00:01 |
|     1 |    TABLE ACCESS BY INDEX ROWID| TAB_IDX_TEST         |         2 |     166 |         2     (0)| 00:00:01 |
|*    2 |     INDEX RANGE SCAN                    | IDX_TAB_IDX_TEST |         2 |             |         1     (0)| 00:00:01 |
------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

     2 - access("OBJECT_NAME"='DBA_INDEXES')

Note
-----
     - dynamic sampling used for this statement

SQL>

分析：

1）从Cost上来看，如果不在OBJECT_NAME创建索引，则

COST为142，CPU占用为3%，Rows为7，Bytes为581

2）如果在OBJECT_NAME创建索引，则

COST为2，CPU占用为0%，Rows为2，Bytes为166

收录于