From oracle-l-bounce@freelists.org Mon May 23 11:31:26 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4NGVQkm027969 for ; Mon, 23 May 2005 11:31:26 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j4NGVQNi027963 for ; Mon, 23 May 2005 11:31:26 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E3AB51AFBA9; Mon, 23 May 2005 10:28:30 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31634-10; Mon, 23 May 2005 10:28:30 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6CBBD1AAE1F; Mon, 23 May 2005 10:28:30 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=i2fI9MfOw/SIzcRylz0nM1QwwUcWsUy6TVHJ8ofzhnyZ4LGNrPPS+GPzD9GEMNmHSSQ7Xtu5Z63jftazJHrNd9hMtJGalqmlKVFYHf/Cyp/Em7f506FDx6HLqaIiqPCGC/TzPwIZ7FWnkx7/LRyd0weCKr+CY2Z98xGMIU7j9B8= Message-ID: Date: Mon, 23 May 2005 08:26:38 -0700 From: Jared Still To: peterdixon001@hotmail.com Subject: Re: Rebuild indexes Cc: oracle-l@freelists.org In-Reply-To: Mime-Version: 1.0 Content-type: text/plain References: Content-Transfer-Encoding: 8bit X-archive-position: 20122 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.6 required=5.0 tests=AWL,MAILTO_TO_SPAM_ADDR autolearn=no version=2.63 In addition to the excellent explanations you have already received, rebuilding this index will cause a considerable amount of extra activity during subsequent inserts while the index bulks itself back up to its former size. Why are you rebuilding it? There is generally no good reason for doing so. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On 5/22/05, Peter Dixon wrote: > > I have an application where data is never deleted, I have just rebuilt an > index which was previously 4gb in size and its now 3gb in size. Can > anybody > explain? > > > -- > http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l