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
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-lReceived on Sat Apr 26 2014 - 06:24:42 CEST