Re: Index key compression - performance benefits?
- From: David Aldridge <david@xxxxxxxxxxxxxxxxxx>
- To: kmoore@xxxxxxxxxxxx
- Date: 29 Aug 2006 10:37:58 -0700
- Date: Tue, 29 Aug 2006 11:37:02 -0600
In the context of memory requirements and disk bandwidth the index size
is rather a critical issue though, so there is a correlation between
segment size and performance.
Fortunately this issue is very amenable to performance testing of the
two alternatives. You might also consider bitmap indexes, even for
columns with a relatively high number of distinct values. Throw those
into the mix and you have the basis for a very nice little comparison.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
