What is an Index Segment ?

Each Index has an Index segment that stores all of its data.

  • Interview Candidate
  • 1
  • 1787

Showing Answers 1 - 1 of 1 Answers

taraldesai

  • Jan 28th, 2008
 

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions