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

Thread: INDEX_STATS

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    Question

    INDEX_STATS gives you what kinds of information? (choose TWO)

    1. Distinct Keys
    2. I/O level
    3. Number of empty blocks
    4. Index level
    5. Average blocks per key
    6. Number of contention blocks

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    I would say (1) and (4).

    SQL> desc index_stats
    Name
    --------------------------
    HEIGHT (4)
    BLOCKS
    NAME
    PARTITION_NAME
    LF_ROWS
    LF_BLKS
    LF_ROWS_LEN
    LF_BLK_LEN
    BR_ROWS
    BR_BLKS
    BR_ROWS_LEN
    BR_BLK_LEN
    DEL_LF_ROWS
    DEL_LF_ROWS_LEN
    DISTINCT_KEYS (1)
    MOST_REPEATED_KEY
    BTREE_SPACE
    USED_SPACE
    PCT_USED
    ROWS_PER_KEY
    BLKS_GETS_PER_ACCESS
    PRE_ROWS
    PRE_ROWS_LEN
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Why 1 & 4:

    2. INDEX_STATS has nothing to do with I/O level
    3. Number of empty blocks is a table level statistics

    5. Average blocks per key is a cluster property.
    6. Number of contention blocks has nothing to do with the structure of an index.

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