Concepts and Architecture Interview Question:

Explain what is an Index Segment?

Submitted by: Administrator

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
Submitted by: Administrator