| Bishal |
Posted: Apr 24, 2008 06:48:26 AM |
Total Post: 207
Joined: Apr, 2008
|
how do we see results of analyze command... what is its use... can anyone send me the link which tells the use and execution of analyze commands
|
|
|
 GOPU |
| Posted: Apr 24, 2008 06:52:38 AM |  |
|
Total Post: 271
Joined: Apr, 2008
|
Hi friend
some information regarding analyze command
The analyze command within the Oracle database collects statistics about an object. The information includes the distribution of data, the number of rows in the table and otehr important statistics. This information is collected and supplied to the optimizer to allow for the best possible execution path of a SQL statement.
If you are using the cost-based optimizer you must analyze your database objects. As well when you are analyzing your objects your should tell the database the size of the sample it should use if you wish to have the database estimate statistics (this is a faster method). If you wish for an exact computation of statistics you would use the "compute" argument.
To estimate statistics:
ANALYZE TABLE tablename ESTIMATE STATISTICS SAMPLE 30 PERCENT;
To compute statistics:
ANALYZE TABLE tablename COMPUTE STATISTICS;
You should also remember that statistics get old and dated, you should regularly schedule to re-analyze your tables and indexes.
Regards
Gopu
|
|
|
|
|
| GOPU |
| Posted: Apr 24, 2008 06:55:54 AM | |
|
Total Post: 271
Joined: Apr, 2008
|
Hi,
please fo throuhg this link you will get some more detailed information about the analyze command..
http://www-eleves-isia.cma.fr/documentation/OracleDoc/ANALYZE.html
Regards
Gopu
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: Apr 24, 2008 07:16:11 AM | |
|
Total Post: 79
Joined: Apr, 2008
|
Please go through the following link ... you will get the answers of all your questions
http://sharear.blogspot.com/search/label/Gather%20Database%20Statistics
regard
Hasan
|
|
|
|
|
| Bishal |
| Posted: Apr 24, 2008 07:23:41 AM | |
|
Total Post: 207
Joined: Apr, 2008
|
|
|
|
|
| Murtuja |
| Posted: Apr 26, 2008 09:03:20 AM | |
|
Total Post: 843
Joined: Jan, 2006
|
Hi,
Don't use analyze command.
You should consider DBMS_STATS to collect statistics since it's Oracle's recommendation.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
