Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ANALYZE Command
So what do you recommend? What is the best solution, this is a
small/medium database?
In article <01bec4be$755fde40$a504fa80_at_mndnet>,
"Suresh Bhat" <suresh.bhat_at_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_at_mailcity.com
>
> flowerss_at_my-deja.com wrote in article <7lgg0t$mpk$1_at_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.
Received on Wed Jul 07 1999 - 12:00:26 CDT