Terimakasih Pak Taufiq banyak atas pencerahannya. Waduh saya ini musti belajar banyak nih tentang dasar2 indexing and tuning. Ada gak yah kursus2 nya di jakarta or resource di internet?
--- Pada Sen, 2/3/09, Taufiq Hidayat <[email protected]> menulis: Dari: Taufiq Hidayat <[email protected]> Topik: Re: [indo-oracle] Rebuild Index Kepada: [email protected] Tanggal: Senin, 2 Maret, 2009, 12:20 AM 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 <rama_aditya_ i...@yahoo. com> To: indo-oracle@ yahoogroups. com 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] Coba Yahoo! Messenger 9.0 baru. Akhirnya datang juga! http://id.messenger.yahoo.com [Non-text portions of this message have been removed]
