-
Index statistics
Hi Gurus,
Is there a way I can find out the efficiency of an Index.
That is I want to know the following details
Allocated blocks
Distinct keys
Times most repeated key is repeated
B-tree space (total allocated space)
Used space
Percent used
Average rows per distinct key
Average blocks gets per access
B-tree height
Leaf rows
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 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.
Thanks
Naeem
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|