Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: searching for records with skewed data values (skewed data changes rapidly)
Pratap wrote:
> You can try partitioning the table on that column. So partition full
> scans hurt that much. You may also test with bitmap indexes.
>
> Pratap Deshmukh
> Cognizant Technology Solutions, India
If updates are taking place this might not be a good place for a bitmap index. And if the values are there only for short periods of time I'd argue that partitioning would be very expensive both in dollars and in the time required for records to move from partition to partition.
The question I have for Matt is simple ... why do you care? What is the issue? And how do you know the issue exists?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Tue Aug 17 2004 - 09:28:18 CDT