hello,
i'm not very familiar with the analyse table
command. and not fully aware of it's advantage or limits to analyse the
tables.
could anyone pls help me with this cmd, how to see
the analysed statistics, etc.
any help is highly appreciated.
thanks in advance.
saurabh sharma
on NT -
C:\> notepad D:\Oracle\Ora81\RDBMS\ADMIN\dbmsutil.sql
in notepad - find "procedure analyze_schema"
sqlplus> exec dbms_utility.analyze_schema('pr0n_kewlecshun','COMPUTE');
hth.
> Saurabh Sharma wrote:
>
> hello,
>
> i'm not very familiar with the analyse table command. and not fully
Title: RE: about analyse table..
Hi Saurabh,
The Analyse command helps to collect information on the specified table and updates the system table called user_tables with this info
This helps to optimize any query which is run on the table after the table is analyzed. You
ot;Saurabh Sharma" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: about analyse table..
>Date: Thu, 22 Mar 2001 22:00:23 -0800
>
>hello,
>
>i'm not very familiar with the analyse
L PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: about analyse table..
>Date: Thu, 22 Mar 2001 22:00:23 -0800
>
>hello,
>
>i'm not very familiar with the analyse table command. and not fully aware
>of it's advantage or limits to
Just a FYI about Analyzing...
As of Oracle 8i, Oracle recommends using the DBMS_STATS package instead of
the ANALYZE command or DBMS_UTILITY procedures. The DBMS_STATS package
gathers more statistics than either ANALYZE or the DBMS_UTILITY packages --
potentially resulting in better query perform