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
Thanks in advance,
[Edited by JONPEARSON on 03-22-2001 at 07:03 PM]
Bitmapped indexs are very small compared to btree indexes for low cardinality columns and can save a lot of space.
Senior Database Administrator
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.
Click Here to Expand Forum to Full Width