-
Finding size of a ito
create table iot (a primary key, owner) organization index as
select object_id, owner from dba_objects where object_id is not null and rownum < 11
Table created.
explain plan for select * from iot;
Explained.
@utlxpls
PLAN_TABLE_OUTPUT
-------------------------------------------------------------------------------------------
Plan hash value: 12198353
-------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 10 | 300 | 2 (0)| 00:00:01 |
| 1 | INDEX FAST FULL SCAN| SYS_IOT_TOP_128290 | 10 | 300 | 2 (0)| 00:00:01 |
-------------------------------------------------------------------------------------------
Notice it only read SYS_OIT_TOP_128290 object.
select owner, index_name, index_type from dba_indexes where table_name ='IOT';
OWNER INDEX_NAME INDEX_TYPE
------------------------------ ------------------------------ ---------------------------
SYS SYS_IOT_TOP_128290 IOT - TOP
select index_name, column_name from dba_ind_columns where index_name = 'SYS_IOT_TOP_128290';
INDEX_NAME COLUMN_NAME
------------------------------ ------------------------------
SYS_IOT_TOP_128290 A
Where is the column owner?
When i issue a query on my iot, it only access the object SYS_IOT_TOP_128290.
When i query SYS_IOT_TOP_128290, in dba_ind_columns, only column a show up. Not owner.
Where does the column owner is stored?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|