Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle Data Compression

Oracle Data Compression

From: Carle, William T (Bill), ALCAS <wcarle_at_att.com>
Date: Thu, 08 Aug 2002 12:38:28 -0800
Message-ID: <F001.004AFBA9.20020808123828@fatcity.com>


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_at_att.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Carle, William T (Bill), ALCAS
  INET: wcarle_at_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_at_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). Received on Thu Aug 08 2002 - 15:38:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US