why do you need to analyze tables?
Printable View
why do you need to analyze tables?
Check this out...
http://technet.oracle.com/docs/produ...tats.htm#25018
HTH.
If you don't analyze tables the cost based optimizer to guess what the best optimization is for your queries assuming that there is no data , the CBO will guess poorly in that case. In general, you will see dramatic improvement after analysis if you have never analyzed.
This is in the case of CBO.
Quote:
To collect or delete statistics about an index or index partition, table or table partition, index-organized table, cluster, or scalar object attribute.
To validate the structure of an index or index partition, table or table partition, index-organized table, cluster, or object reference (REF).
To identify migrated and chained rows of a table or cluster.
Does analyzing tables give details of chained rows and the migrating ones?
Thank you
That is wat doc says.
I quote posted is from oracle doc site....
generic syntax is
ANALYZE TABLE table_name
LIST CHAINED ROWS INTO table_name_u_want_to_have_result;
Yea, it does...Quote:
Originally posted by aspdba
Does analyzing tables give details of chained rows and the migrating ones?
Check this out for more info...Code:analyze table temp list chained rows into chained_rows;
http://www.oracle.com/oramag/code/ti...ml?012201.html
HTH.