Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What does an Index exactly contan?

AB312062Apr 3 2013 — edited Apr 9 2013
Hi

I have a doubt if index actually contains the rowid or the data values of column or both?

As per Oracle docs:
"An index is a schema object that contains an entry for each value that appears in the indexed column(s) of the table or cluster and provides direct, fast access to rows."

Can anybody explain this please? What happens when an index contains more than one column?

Also, I need some information in Index Organised tables. Is it a normal database table with index in it or something different? Any study material on this would be useful.


Thanks
AB
This post has been answered by Karthick2003 on Apr 3 2013
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 7 2013
Added on Apr 3 2013
3 comments
152 views