as
select * from dba_objects
where owner in('PUBLIC','SCOTT','SYS','SYSTEM');
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>
on tab_idx_test(object_name);
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>