Indexes in Oracle

 

Level of Blocks means Height of Index

i.e. Level of Block = Height of Index

Height = Root block to Leaf blocks

 

 

To view the height you will have to validate the structure

 

 SQL> select * from hr.empl_demo where employee_id=200;

 

SQL> select employee_id from hr.empl_demo order by employee_id;

SQL> select count(EMPLOYEE_ID) from hr.empl_demo;

SQL> select dep_id,sum(salary) from hr.empl_demo group by dept_id;