Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: searching for records with skewed data values (skewed data changes rapidly)

Re: searching for records with skewed data values (skewed data changes rapidly)

From: Pratap <pratap_fin_at_rediffmail.com>
Date: 17 Aug 2004 06:03:39 -0700
Message-ID: <830861d2.0408170324.73367cc6@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US