Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!nntp.abs.net!feeder.qis.net!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail From: allanwtham@yahoo.com (godmann) Newsgroups: comp.databases.oracle.server Subject: Re: analyze index and cost Date: 3 Mar 2002 21:48:22 -0800 Organization: http://groups.google.com/ Lines: 20 Message-ID: <95cd51c.0203032148.4e6c9df5@posting.google.com> References: <3C7FAAE9.C3F26803@ci.seattle.wa.us> <3C82C093.49EFE0D3@ci.seattle.wa.us> NNTP-Posting-Host: 161.142.78.83 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1015220903 28364 127.0.0.1 (4 Mar 2002 05:48:23 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 4 Mar 2002 05:48:23 GMT Xref: easynews comp.databases.oracle.server:137344 X-Received-Date: Sun, 03 Mar 2002 23:28:40 MST (news.easynews.com) Howard, How do you revert back says analyze .. compute statistics is bad? If that is the case what is the point of analyzing some tables or indexes with a view to provide better stats. Oracle may not use it at all! I always thought that at all times, I should do analyze to make it run faster! Allan W. Tham Oracle DBA >>All I wanted to point out here is that computing statistics does NOT mean >>'things go faster', it means that the optimizer has some basis on which to >>work out an *intelligent* approach to getting at the data, rather than just >>blindly following a set of 15 rules that haven't changed in years. Usually >>that *would* mean performance improvements, but there are plenty of >>configuration and coding issues which can stop that happening. They need to >>be diagnosed and resolved -and that simply can't be done in the absence of >>any further information from you.