Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

B*-tree problem

Status
Not open for further replies.
wally1

wally1

Technical User
Mar 24, 2003
27
IT
Hi guys,
i am working with Oracle 8.1.7.4.0 version os Solaris 8 Operative System. With Oracle Enterprise Manager i check a SQL inside a particul session.
I read that Oracle use to run that particular sql command an B*-tree index 3 (i think 3 is the number of the max children for a node).
there is a method to know why Oracle have set 3 how B*-tree level ????
Thanks all
Walter
 
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Button not aligned after click
Replies
0
Views
308
TheLazyPig
TheLazyPig
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
968
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
Can deleted files/ directories (rm -r) be retrieved again?
Replies
6
Views
664
Livia8
Livia8
harfri
  • Locked
  • Question
Insert data from Table A into Table B how can I do that?
Replies
3
Views
409
carp
carp
mibeach7
  • Locked
  • Question
Group by challenge 1
Replies
5
Views
410
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top