Index height

From: Orlando L <>
Date: Fri, 25 Apr 2014 23:24:42 -0500
Message-ID: <>


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

Received on Sat Apr 26 2014 - 06:24:42 CEST

Original text of this message