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: determining usage of histograms

Re: determining usage of histograms

From: Ben <balvey_at_comcast.net>
Date: 10 Mar 2006 13:02:49 -0800
Message-ID: <1142024569.657205.164260@i39g2000cwa.googlegroups.com>


another question.
Does dbms_utility.analyze_schema('schema_name',COMPUTE) give the same results as dbms_stats.gather_schema_stats('owner', cascade=>true) ?

It looks like both have created enpoint values for every column in user_histograms. Received on Fri Mar 10 2006 - 15:02:49 CST

Original text of this message

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