problem with subpartitioned tables after load and analyze

HI
We have a datawarehouse with large composite-paritioned tables. A strange problem seldom occurs when, after loading of monthly data in a new partition (in some cases about 20 million rows) and execute the analyze command on that partition (with compute statistics), a query such "select count(*) from table_name where date_field ='31-DEC-2000 " returns 0 rows, while "select count(*) from table_name partiton(DEC_2000) " returns the correct value. I suspected that's due to something concerned with bitmaps indexes (all indexes, including primary keys, are local), because sometimes (but not always) rebuilding them (but their state where usable), fixed the problem..

Any suggestions?

thanks Received on Mon Feb 19 2001 - 10:56:06 CST