What does an Index exactly contan?
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