Indexes: Analyze Index

Description: Analyze a table index and show distinct keys, average leaf blocks per key, average data blocks per key, etc.

SET linesize 121
col avg_leaf_blocks_per_key format 999
col avg_leaf_blocks_per_key head leafs_key
col avg_data_blocks_per_key format 999
col avg_data_blocks_per_key head data_key
 
SELECT index_name,blevel,distinct_keys,
avg_leaf_blocks_per_key,avg_data_blocks_per_key
FROM user_indexes;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.