oracle sqldeveloper - Finding the height of the B-Tree of a table in SQL-Developer -
let's suppose need estimate te costs of entire explain plan of sql query, 1 sql-developer shows. there somewhere information, height mean, of b-trees builted on indexes of table? or how can estimate it?
in all_indexes view found looking for. here oracle documentation attributes can select index. in case:
select index_name, blevel all_indexes table_name = 'table_name';
from oracle doc on blevel
attribute:
b*-tree level: depth of index root block leaf blocks. depth of 0 indicates root block , leaf block same.
Comments
Post a Comment