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 can take help
if you have your database in the "CHOOSE" mode for the optimizer (using the
cost-based optimizer) and you don't analyze your tables, Oracle doesn't have
good information to determine the query path.
If you do "analyze table tablename compute statistics" the entire table is
read to gather the
Can't you also analyze an entire schema to make it easier, there's a dbms
package in the admin directory?
kev
-Original Message-
Carmichael
Sent: Friday, March 23, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L
if you have your database in the "CHOOSE" mode for the optimizer
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
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