Re: Analyze tables

From: Van Messner <vmessner_at_netaxis.com>
Date: Thu, 16 Sep 1999 17:53:16 -0400
Message-ID: <cFdE3.15049$N77.1120294@typ11.nn.bcandid.com>

You need to read about Rule and Cost based optimization. Then check to see what the two databases are doing. Be sure NOT to analyze objects owned by SYS or SYSTEM.

Van

Pascale Marois <pascalem_at_total.net> wrote in message news:XybE3.415$HU1.60883_at_news.total.net...
> I'm very new a the role of DBA and I would like to submit this question:
>
> Two weeks ago, I runned a script to analyze all the tables on the
> development database. Everything was fine and then, last week, I runned
the
> same script on the production database. After this, many SELECT were
> extremely slow. I had to delete statistics on many tables and then
> everything was OK.
>
> I can't explain why it didn't work. The development database has
> approximately the same size then the production one.
>
> Does someone can explain it for me?
>
>
>
Received on Thu Sep 16 1999 - 16:53:16 CDT