-
analyze tables
why do you need to analyze tables?
-
-
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.
-
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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;
Last edited by abhaysk; 03-19-2003 at 07:30 AM.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Originally posted by aspdba
Does analyzing tables give details of chained rows and the migrating ones?
Yea, it does...
Code:
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|