Home » SQL & PL/SQL » SQL & PL/SQL » Index concept (Oracle 9.2.0.3)
Index concept [message #409138] Fri, 19 June 2009 10:49 Go to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
I am a bit confused here. I want to know which one is used by oracle- Btree or B+ tree?
Is there any link from here I cann get some example of how data are stored in index and accessed.

I went through the Oracle concept guide but i could not understand the concept well.

Is there any link from which I can understand the index concept? Is there any pictorial demonstration
which helps to undersatnd.

Many thanks for the help!
Re: Index concept [message #409140 is a reply to message #409138] Fri, 19 June 2009 11:03 Go to previous messageGo to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
http://www.authorstream.com/Presentation/BeatRoot-31240-Ch10-BTree-Tree-Index-Motivation-Content-Structure-Equality-Search-Range-Tree s-Practice-Inserting-Data-as-Entertainment-ppt-powerpoint/


http://www.geocities.com/SiliconValley/Program/2864/File/btree.html



Which one is used in Oracle?
Re: Index concept [message #409146 is a reply to message #409138] Fri, 19 June 2009 12:26 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Richard Foote, Index Internal:
http://bbs.wisky.org/doc/internal.docs/Richard%20Foote-Oracle%20Index%20Internal.pdf

Regards
Michel
Previous Topic: How to manipulate data read from file using utl_file package - 10g - xp sp3
Next Topic: function
Goto Forum:
  


Current Time: Sat Feb 08 06:29:14 CST 2025