Data Warehousing Options
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Data Warehousing Options

  1. #1
    Join Date
    Feb 2001
    Posts
    4
    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,

    Jon

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

  2. #2
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    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.
    (877)687-3227

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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.
    Reddy,Sam

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