Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    4

    Unanswered: Optdiag Derived Statistics

    Hi

    I am interested in leaning the formula in the optdiag utility used to calculated the following derived statistics

    Table statistics
    Data page cluster ratio
    Space utilization
    Large I/O efficiency

    Index Statistics
    Data page cluster ratio
    Index page cluster ratio
    Data row cluster ratio
    Space utilization for an index
    Large I/O efficiency for an index

    Regards,

    Simon Grzebieta

  2. #2
    Join Date
    Feb 2009
    Posts
    4
    Hi everyone

    I have found a solution to my problem, there is a stored procedure called DERIVED_STAT(OBJECT_NAME,OBJECT_ID,"STATISTIC") which can calculate the statistics I required

    Regards,

    Simon Grzebieta

Posting Permissions

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