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: DBMS_STATS and partitioned tables with Bitmap indexes

Re: DBMS_STATS and partitioned tables with Bitmap indexes

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 25 Oct 2006 14:35:29 -0700
Message-ID: <1161812128.332282@bubbleator.drizzle.com>


Dereck L. Dietz wrote:
> We're in the process of switching old code over from using ANALYZE to the
> DBMS_STATS and have run into something we can't figure out.
>
> We have a large partitioned table of over 72 million rows and 10 partitions.
> When we run DBMS_STATS on the table with bitmap indexes the DBMS_STATS will
> take up to 4 hours to complete. However, if we drop the bitmap indexes and
> replace them with normal b-tree indexes the DBMS_STATS will only take about
> 20 minutes.
>
> When the DBMS_STATS is run on an equally large, not non-partitioned, table
> with bitmap indexes the DBMS_STATS will complete in roughly the same time as
> the partitioned table without bitmap indexes.
>
> Is this normal behavior for the DBMS_STATS? Is there a special parameter or
> something we have to use for the bitmap indexes on large partitioned tables?
>
> We're running Oracle 10g R2 version 2.02.

I haven't seen it ... but wouldn't a bit of statistical sampling be preferable to gathering details on every row?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Oct 25 2006 - 16:35:29 CDT

Original text of this message

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