View Single Post

   
  #13 (permalink)  
Old 02-27-2008, 06:44 AM
m0002a@yahoo.com
 
Posts: n/a
Default Re: type-2 index causing performance hit

The number of levels is contained in the syscat.indexes tables as
documented in Appendix D fo the SQL Reference Vol 1. This value is
updated after you run runstats command on the index.

Reply With Quote