-
dear friends
while analyzing a table for computing/estimating statistics,(for cost based
optimization) what are the factors that are to be considered from the
dba_tables where the details are stored. how can we use these details
for further review.
thanks in advance
-
Cost based optimizer will automatically use statistics generated by analyse command for generating execution plans.
You can find out the extent of chaining in your tables (fron chain_cnt column). There would be other uses as well, which others can highlight.
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
|