Re: Help ! How to use analyze command

Instead of using COMPUTE, I would recommend using ESTIMATE Statistics unless you have lots of CPU idle time. According to Oracle (and my own experiences), ESTIMATE will be within 3% as accurate as COMPUTE and will take a fraction of the time.

I have found that doing an analyze on your most heavily used (updates, deletes, inserts) tables on a regular basis (every night in some cases, weekly in others) will help increase your speed significantly (provided your indexes and code are done right, of course!).

The next 2 greatest speed improvements are lots of RAM (which allows you to make sort_area_size larger for more sorts in RAM) and reducing fragmentation (in many cases either through REORGS of the database OR using Locally Managed Tablespaces)..

Just my humble opinion.

Jim

In article <8j2qtb$38v$1_at_nnrp1.deja.com>, michael_bialik_at_my-deja.com says...
>
>Hi.
>
> ANALYZE TABLE my_tab COMPUTE STATISTICS;
>
> After execution:
>
> SELECT table_name, num_rows FROM user_tables
> WHERE table_name = 'my_tab';
>
> You are supposed to see the actual number of rows in your table.
>
> SELECT * FROM user_tables -- dba_tables, all_tables
> WHERE num_rows IS NULL;
>
> Will give you a list of all NON_analyzed tables.
>
> HTH. Michael.
>
>
>In article <8ivck1$4eg$1_at_news.seed.net.tw>,
> "Peter.Chen" <wizard_at_saturn.seed.net.tw> wrote:
>> Can any one tell me how to use analyze ?
>> Is any table I can check the result ?
>> Or I will get a file .
>> thanx you ^_^
>> wizard_at_saturn.seed.net.tw
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sun Jul 23 2000 - 00:00:00 CEST