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)
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
Received on Tue Aug 17 2004 - 08:03:39 CDT