Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g78JtQt19903 for ; Thu, 8 Aug 2002 15:55:26 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id MAA45195; Thu, 8 Aug 2002 12:52:38 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 004AFBA9; Thu, 08 Aug 2002 12:38:28 -0800 Message-ID: Date: Thu, 08 Aug 2002 12:38:28 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Carle, William T (Bill), ALCAS" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Carle, William T (Bill), ALCAS" Subject: Oracle Data Compression Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by naude.co.za id g78JtQt19903 Howdy, I attended a seminar on Oracle data compression in version 9.2 this morning. There are no web-based handouts to look at. However, there are a few items on it that may be of interest: Data compression is based on duplicate fields Compression is only done on direct operations ( for example, an ordinary insert is not compressed) Indexed queries would not be any faster against compressed data (The index is not compressed, just the data.) Updates are 10-20% slower. Deletes are 10% faster. Full table scans are much faster. Bottom line is that this would mainly be used for a data warehousing application with lots of full table scans. It wouldn't be used for anything with lots of updating or online queries. Also, we were told that 9.2 is the terminal release of 9i. The next version will be 10i. Bill Carle AT&T Database Administrator 816-995-3922 wcarle@att.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: wcarle@att.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).