Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_STATS and partitioned tables with Bitmap indexes
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.orgReceived on Wed Oct 25 2006 - 16:35:29 CDT