Re: Help ! How to use analyze command

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 Sat Jun 24 2000 - 00:00:00 CEST