Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Index fragmentation and Performance.
Dear all,
I read some where that index fragmentation does not lead to performance
decrease though it leads to wastage of space. Can somebody explain how
index blocks are read. ie
Is index block directory stored in the index header ? and oracle reads
only the header of the index to go to the desired block or something
else happens. The only thing I could think of is that since indexes are
b-trees and this b-tree is stored in the index header so oracle can find
which block to visit so even if some blocks are empty in the index
segment, oracle need not visit those blocks as in full table scan.. All
thoughts are welcome.
Regards
Received on Fri Apr 02 1999 - 10:39:25 CST
![]() |
![]() |