Re: select count(*)

From: GC <assistant_madman_at_hotmail.com>
Date: 2000/07/28
Message-ID: <39821DA7.18B9DBA7@hotmail.com>#1/1

Raymond Wong wrote:
>
> Hi,
>
> I am new in ORACLE. I tried the analyse statement but it does not show
> anything:
>
> analyze table item compute statistics
>
> it displays nothing. Would you mind teaching a newbie a bit?

The analyze statement will populate statistics in the dba_tables and dba_indexes data dictionary views. The stats will be used by the cost-based optimizer to pick (hopefully) the optimal data retrieval path. Nothing will be sent to stdout - that is, you will see nothing reported back to the screen other than 'table analyzed'.

Cheers,
GC Received on Fri Jul 28 2000 - 00:00:00 CDT