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