Re: What is UPDATE STATS???

In the documentation look up the following commands:

analyze table ..... compute statistics;

and

analyze index ...

These are the commands to update stats.

Kenny Gump

Fantail wrote in message <7mgv7j$qdq_at_tandem.CAM.ORG>...
>Several Oracle consultants told me that to optimize my database, I should
do
>an
>UPDATE STATS regularly. They told me that Oralce documentation explains it
>clearly. I looked in the Oracle docum and I found nothing about it.
>
>Can someone can give me a hint please?
>
>Thanks.
>
>
>
>
Received on Wed Jul 14 1999 - 17:24:38 CEST