Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Index fragmentation and Performance.

Index fragmentation and Performance.

From: Devinder Pal Singh <Devinder_Pal.Singh_at_pharma.novartis.com>
Date: Fri, 02 Apr 1999 11:39:25 -0500
Message-ID: <3704F2BC.3C60F439@pharma.novartis.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US