An Index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns
A Cluster with an index on the Cluster Key.
Data Segment, Index Segment, Rollback Segment and Temporary Segment.
Latest Answer : Data, index , rollback, undo,cluster ...
Each Index has an Index segment that stores all of its data.
Latest Answer : It's an oracle object as other object like table. It stores index key + rowid for that key. So when you scan index it finds respective rowid and fetch data from that rowid. and it's faster ...
Latest Answer : Bitmap index:------------A type of index that uses a string of bits to quickly locate rows in a table. Bitmap indexes are normally used to index low cardinality columns in a warehouse environment.Btree index:------------A type of index that ...
