Re: ANALYZE SCHEMA

From: David B. Fowler <dfowler_at_surfree.com>
Date: Thu, 14 Oct 1999 22:00:04 -0500
Message-ID: <3806978a@exchange.surfree.com>

Comin,
To collect stats on your tables,indexes...If you are planning on using the Cost Based optimizer (CBO) This should be done daily for an OLTP system or after a dataload on a Datawarehouse. To get more info check the dbms_utility package in sys. There are several options.

hth,
Dave Fowler
Developer/DBA

Cosmin Ioan <cosmin_ioan_at_msn.com> wrote in message news:ead8qnaF$GA.177_at_cpmsnbbsa05...
> hello all,
>
> I was wondering if there are any drawbacks to executing ANALYZE SCHEMA!?
Is
> this is good idea as a maintenance, every few months or so?
>
> Thanks,
>
> Cosmin
>
>

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Thu Oct 14 1999 - 22:00:04 CDT