Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Vinesh.

Asked: January 13, 2017 - 11:21 am UTC

Last updated: January 15, 2017 - 5:00 am UTC

Version: 11g

Viewed 1000+ times

You Asked

Team,

Generally talking about the Indexes, it is considered as an object which assists in fetching the data faster or quickly.

But i would like to know the internals of index, like how index is stored and index leaf node,branch node and index root etc.

having an idea on this would assist us in understanding the index internals for partitioned tables/ partitioned indexes

Any suggestions in this regard most welcome.

Regards,
Vinesh

and Connor said...

Here is an awesome presentation on it by Julian Dyke

www.juliandyke.com/Presentations/IndexInternals.ppt


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Oracle Index Internals

Vinesh, January 16, 2017 - 11:32 am UTC

Thanks a Ton For Your quick response.

I have received for what I have been looking at.

Any further suggestions regarding oracle Index internals most welcome.