Re: ANALYZE Command

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Fri, 02 Jul 1999 17:12:21 GMT
Message-ID: <01bec4be$755fde40$a504fa80@mndnet>

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.
>
Received on Fri Jul 02 1999 - 12:12:21 CDT