Index extents

Posted in 2005

Terrence Mullins — Fri, 21 Jan 2005 16:04:23 — source: IIUG Forums & Mailing Lists

All, Is there a way to size the index extents if they are detached? I'm seeing alot of extents allocated to indexes (150+ extents). -Terrence

↪ replying to Terrence Mullins

ART KAGEL, BLOOMBERG/ 731 LEXIN — Fri, 21 Jan 2005 16:18:53 — source: IIUG Forums & Mailing Lists

Index extent size is auto-calculated as a percentage of the table's extent sizing. The ratio is the ratio of the keysize to the rowsize. So, increase the table's NEXT SIZE and reorg it, then rebuild the indexes. This should compress the index into fewer larger extents. Art S. Kagel ----- Original Message ----- From: Terrence Mu.... <terrence@wagerworks.com> At: 1/21 11:10 > All, > > Is there a way to size the index extents if they are detached? I'm seeing alot > of extents allocated to indexes (150+ extents). > > > > > -Terrence