analyze tables

[netbar]

why do you need to analyze tables?

[ggnanaraj]

Check this out...

http://technet.oracle.com/docs/produ...tats.htm#25018

HTH.

[mkumarnk]

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.

[abhaysk]

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.

[aspdba]

Does analyzing tables give details of chained rows and the migrating ones?

Thank you

[abhaysk]

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;

[ggnanaraj]

Originally posted by aspdba
Does analyzing tables give details of chained rows and the migrating ones?

Yea, it does...

analyze table temp list chained rows into chained_rows;

Check this out for more info...

http://www.oracle.com/oramag/code/ti...ml?012201.html

HTH.