DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2001
    Are there any data compression options when working with Oracle databases?
    I know this is broad but can partitioning and indexing be used in certain ways
    in order to reduce storage (i.e. use partitioning in order to reduce indexing in
    order to save storage?)
    I need to have data available that may be accessed once a month and I would
    like to keep in online or somewhat easily accessible --without it taking up so
    much space.

    Thanks in advance,


    [Edited by JONPEARSON on 03-22-2001 at 07:03 PM]

  2. #2
    Join Date
    Jul 2000
    Oxford, OH
    Bitmapped indexs are very small compared to btree indexes for low cardinality columns and can save a lot of space.
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.

  3. #3
    Join Date
    Feb 2000
    Washington DC
    If you could find time, search on latest magazines of Oracle. There is beutiful column on bitmapped index which shows clearly the difference of space occupied from regular index to bitmapped.

    I will try posting the link if I find it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.