Concepts and Architecture Question: Download Oracle Architecture and Concepts PDF
Explain what is an Index Segment?
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
| Previous Question | Next Question |
| Tell me what is the difference between materialized view and snapshot? | Explain the different type of Segments? |