Index height

From: Orlando L <oralrnr_at_gmail.com>
Date: Fri, 25 Apr 2014 23:24:42 -0500
Message-ID: <CAL8Ae75RJhDEwcC4gCdcbGmaKCnA9XYJb+-7G+pAL5nT_93cPQ_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 26 2014 - 06:24:42 CEST

Original text of this message