| |
Posted: May 07, 2008 06:32:48 AM |
Total Post: 22
Joined: Feb, 2008
|
Q1. What is Index Tree ?
Q2. What is the difference between segement and object? |
|
|
Murtuja |
| Posted: May 07, 2008 07:30:47 AM | |
|
Total Post: 588
Joined: Jan, 2006
|
Hi,
read it from any book for Oracle DBA.
|
|
|
|
|
Mohammed Taj |
| Posted: May 07, 2008 09:29:30 AM | |
|
Total Post: 634
Joined: Jul, 2007
|
and if your not found any book then go http://tahiti.oracle.com
will give your alots of books in detail with free....
|
|
|
|
|
dbavinod |
| Posted: May 12, 2008 08:38:14 AM | |
|
Total Post: 81
Joined: Sep, 2006
|
The data is in the segments of objects (data segments, index segments, rollback segments, and so on)
The level of logical database storage above an extent is called a segment
index tree is a is a balanced index tree data structure optimized for cases where both the index and the actual data are fully kept in memory
A tree structure is a way of representing the hierarchical nature of a structure in a graphical form. It is named a "tree structure" because the graph looks a bit like a tree, even though the tree is generally shown upside down compared with a real tree; that is to say with the root at the top and the leaves at the bottom.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |