Observation: Many Index Levels

The number of levels in the index b-tree structure exceeds the limit for an index; larger numbers of index levels require more index I/O. Generally, you can improve performance by reducing the index levels to less than three. To reduce the number of levels, minimize the key defined for the index, or partition the tablespace.