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
Bookmarks