DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: analyzing a table

  1. #1
    Join Date
    Sep 2001
    Location
    chennai
    Posts
    69
    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

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    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.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width