Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!cyclone1.gnilink.net!canoe.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: devnull@ronr.nl (Ronald Rood) Newsgroups: comp.databases.oracle.server Subject: Re: Need opinions on "Compute Statistics" Date: 6 Jun 2003 02:00:37 -0700 Organization: http://groups.google.com/ Lines: 23 Message-ID: <67ce88e7.0306060100.4b9e3f13@posting.google.com> References: <1e271843.0306040711.3fe6d3bb@posting.google.com> <0ibsdv8ecqthjohmp8285frf2v75j8o4jf@4ax.com> <3EDF1BD3.558D@yahoo.com> NNTP-Posting-Host: 212.241.41.253 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1054890037 7795 127.0.0.1 (6 Jun 2003 09:00:37 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 6 Jun 2003 09:00:37 GMT Xref: core-easynews comp.databases.oracle.server:188831 X-Received-Date: Fri, 06 Jun 2003 01:59:54 MST (news.easynews.com) Connor McDonald wrote in message news:<3EDF1BD3.558D@yahoo.com>... > Sybrand Bakker wrote: > > > > On 4 Jun 2003 08:11:31 -0700, aoshell2@yahoo.com wrote: > > To reply remove -verwijderdit from my e-mail address > > "The same applies to statistics without histograms." > > An excessive number of histograms merely serves to pollute the > dictionary cache and add to parse times... And don't forget the fact that when using bind variables the histograms are useless. The plan is only calculated when the qry is parsed for the first time and all re-executions use the same plan, regardless off the values of the bind variables. A datawarehous can't do without histograms. In such an environment it makes no sense to use bind variables. In 'my' databases I create histograms for those indexes that have a large number of leafblocks per key. Ronald. ----------------------- http://ronr.nl/unix-dba