Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 2512 invoked from network); 2 Feb 2006 22:15:56 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 2 Feb 2006 22:15:56 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D1C2C2923C1; Thu, 2 Feb 2006 23:15:56 -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 14569-08; Thu, 2 Feb 2006 23:15:56 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 514A42923B5; Thu, 2 Feb 2006 23:15:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 02 Feb 2006 23:15:40 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BF958292128 for ; Thu, 2 Feb 2006 23:15:40 -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 14486-05 for ; Thu, 2 Feb 2006 23:15:40 -0500 (EST) Received: from smtp812.mail.ukl.yahoo.com (smtp812.mail.ukl.yahoo.com [217.12.12.202]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 45E8929170C for ; Thu, 2 Feb 2006 23:15:40 -0500 (EST) Received: (qmail 21385 invoked from network); 3 Feb 2006 04:15:38 -0000 Received: from unknown (HELO porgand) (tanel@btinternet.com@200.33.188.60 with login) by smtp812.mail.ukl.yahoo.com with SMTP; 3 Feb 2006 04:15:37 -0000 Message-ID: <131301c62878$7ac03040$c6bc21c8@porgand> From: =?iso-8859-1?Q?Tanel_P=F5der?= To: "ORACLE-L" Subject: Re: Index compression on Oracle 9.2 Date: Thu, 2 Feb 2006 22:15:30 -0600 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-archive-position: 30743 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tanel.poder.003@mail.ee Precedence: normal Reply-To: tanel.poder.003@mail.ee X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net (pressed send too fast) It depends where you're standing - a DW DBA or someone having to deal with lots of audit data stored over long period of time would rank table compression quite high. OLTP DBAs don't have any value for this feature. Tanel. -- http://www.freelists.org/webpage/oracle-l