Is there a way I can find out the efficiency of an Index.
That is I want to know the following details
Times most repeated key is repeated
B-tree space (total allocated space)
Average rows per distinct key
Average blocks gets per access
Leaf blocks In Be
Size of all leaf rows
Size of all leaf blocks in B-tree
Deleted leaf rows
Size of all deleted leaf rows
Branch blocks in B-tree
Size of all branch rows
Size of all branch blocks in B-tree
Is there a view gives me the above details.
Click Here to Expand Forum to Full Width