Re: DBMS_STATS cannot analyze clusters

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Thu, 21 Apr 2011 15:26:20 -0700 (PDT)
Message-ID: <0056207c-9a02-4558-a884-47eea994794f_at_v31g2000vbs.googlegroups.com>



Randolf:

# Note that DBMS_STATS actually leaves out the CLUSTER object itself which is analyzed by ANALYZE but the CBO does not seem to use the statistics generated by ANALYZE on the cluster itself.

Mladen:

... I had a query that didn't get the right plan until the cluster was analyzed with the ANALYZE command.

Can you come up with a reproducible test case?

Something that proves the CBO does use statistics generated by ANALYZE that dbms_stats apparently does not populate? Received on Thu Apr 21 2011 - 17:26:20 CDT

Original text of this message