Oracle index nodes are not physically deleted when table rows are deleted, nor are the entries removed from the index. Rather, Oracle "logically" deletes the index entry and leaves "dead" nodes in the index tree where that may be re-used if another adjacent entry is required. However, when large numbers of adjacent rows are deleted, it is highly unlikely that Oracle will have an opportunity to re-use the deleted leaf rows, and these represent wasted space in the index. In addition to wasting space, large volumes of deleted leaf nodes will make index fast-full scans run for longer periods.
for complete article, di om burleson Best Regards, Taufiq ________________________________ From: rama aditya <[email protected]> To: [email protected] Sent: Monday, March 2, 2009 11:23:04 AM Subject: [indo-oracle] Rebuild Index Dear Para Master sekalian, Saya ingin tanya tentang Rebuild Index nih, 1. Apa yang sebenarnya dilakukan Oracle waktu kita rebuild index? 2. When do we need to do that? 3. What's the advantage? 4. What kind and which index do we need to rebuild? Regards, Rama Nikmati chatting lebih sering di blog dan situs web. Gunakan Wizard Pembuat Pingbox Online. http://id.messenger .yahoo.com/ pingbox/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
