Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!193.141.40.65.MISMATCH!npeer.de.kpn-eurorings.net!npeer-ng1.de.kpn-eurorings.net!newsfeed.freenet.de!xlned.com!feeder3.xlned.com!feeder.news-service.com!postnews.google.com!o6g2000yql.googlegroups.com!not-for-mail From: Randolf Geist Newsgroups: comp.databases.oracle.server Subject: Re: oracle update query is taking lot of time.. Date: Sat, 4 Apr 2009 01:37:31 -0700 (PDT) Organization: http://groups.google.com Lines: 27 Message-ID: References: <89ea2188-6c09-474e-9d28-e77e07f239a3@h28g2000yqd.googlegroups.com> NNTP-Posting-Host: 87.178.68.1 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1238834251 3503 127.0.0.1 (4 Apr 2009 08:37:31 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sat, 4 Apr 2009 08:37:31 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: o6g2000yql.googlegroups.com; posting-host=87.178.68.1; posting-account=l5e9UwoAAACVOObO40ZuWRhYrDAs6n0B User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.8) Gecko/2009032609 Firefox/3.0.8,gzip(gfe),gzip(gfe) Xref: news.cambrium.nl On Apr 3, 10:08=A0am, Mladen Gogala wrote: > > I am not at all certain that 10.2 will use histograms collected this way. > I will try running that with the event 10053 and will post the results. > The database is 10.2.0.4, so the results should be relevant. Mladen, for an example of histograms on function-based index columns being used for 10.2.0.4, see e.g. one of recent my blog entries: http://oracle-randolf.blogspot.com/2009/03/getting-accurate-cardinality-est= imates.html That's why I explicitly mentioned 10.2, since I haven't tested it recently in releases prior to 10g, but I'm quite sure that at least 9.2 behaves the same way, may be even 8i. Regards, Randolf Oracle related stuff blog: http://oracle-randolf.blogspot.com/ SQLTools++ for Oracle (Open source Oracle GUI for Windows): http://www.sqltools-plusplus.org:7676/ http://sourceforge.net/projects/sqlt-pp/