Index height

From: Orlando L <oralrnr@xxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 25 Apr 2014 23:24:42 -0500

List

I decided to check the height of indexes used in our databases as part of
my learning experience. In the biggest OLTP database (550 GB) that I
maintain I saw about a 100 indexes with height of 4 (3 blvl+1), a 1000 with
height 3.

I was expecting some big bad 'heights' for indexes. Do the listers have big
indexes lurking in their neck of the woods?

Thank you all
Orlando

Follow-Ups:
- RE: Index height
  - From: Jonathan Lewis

Other related posts:

» Index height - Orlando L
» RE: Index height- Jonathan Lewis
» RE: Index height- Mark W. Farnham