Xref: alice comp.databases.oracle.server:56383
Path: alice!news-feed.fnsi.net!news.idt.net!netnews.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: flowerss@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Re: ANALYZE Command
Date: Wed, 07 Jul 1999 17:00:26 GMT
Organization: Deja.com - Share what you know. Learn what you don't.
Lines: 50
Message-ID: <7m0130$i7h$1@nnrp1.deja.com>
References: <7lgg0t$mpk$1@nnrp1.deja.com> <01bec4be$755fde40$a504fa80@mndnet>
X-Article-Creation-Date: Wed Jul 07 17:00:26 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)
X-Http-Proxy: 1.1 x21.deja.com:80 (Squid/1.1.22) for client 130.207.203.148

So what do you recommend?  What is the best solution, this is a
small/medium database?




In article <01bec4be$755fde40$a504fa80@mndnet>,
  "Suresh Bhat" <suresh.bhat@mitchell-energy.com> wrote:
> Hi -
>
> I want to re-iterate what Vinod said in this thread.
>
> Either you analyze all the tables in your SQL statement or none at
all,
> especially the tables that are joined in creating a view.
>
> We got bitten by this a while ago.  Selecting from a view took almost
2
> hours where as before we analyzed 1 of the 4 joined tables for the
view it
> took only seconds.  One of the joined table that was not analyzed had
about
> 1 million rows.
>
> Suresh Bhat
> Oracleguru
> www.oracleguru.net
> oracleguru@mailcity.com
>
> flowerss@my-deja.com wrote in article <7lgg0t$mpk$1@nnrp1.deja.com>...
> > I've just started performance tuning a database
> > and I don't understand the logic of the ANALYZE
> > command.  I ran the command; however, I don't
> > understand how to make use of it. Specifically,
> > the Endpoint_Number and Endpoint_Value Field?
> >
> > Please help.
> >
> > Thanks,
> > Selena
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
> >
>


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.