Re: ANALYZE Command

From: Vinod <venkatesh.vinod_at_in.bosch.com>
Date: 1999/07/02
Message-ID: <01bec44b$1bf847c0$190394ad@QCS_02_95W.BSN.BOSCH.INDIA.DE>#1/1

Hello Selena,

This is not an answer to your question. But, it will definitely be of help to you.

Looks like you have just started using analyse command on the tables. If YES, then you were running all your application's reports using RULE-based
optimiser. and all your reports may have been TUNED for RULE-Based.

  Now, since you have run "analyse" command, your Database Optimiser will uset
  COST-Based approach. So, your reports, which were tuned first for RULE based,
  will run much slower, since the tuning rules for RULE-Based and COST-Based are
  different.

Just a tip to watch out for.

Regards,
Vinod.

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 - 00:00:00 CDT