Re: to many extents for indexes

Posted in 1998

Bill Ennis — Fri, 20 Feb 1998 13:20:15 CST — source: Informix-list mailing list archive (1991-1998)

You can't control the sizes of indexes extents if they are detached from the data. The sizes are calculated and set by the engine. At least this is true in 7.22. -Bill > > I can control first extent, next extent for tables=20 > but I have many indexes with 20 or more extents > how do I control extent sizes for indexes? > > > ***************************************************************************= > ***** > **** Jack Russo email: jack=2Erusso@frx=2Eco= > m **** > *** Forest Laboratories phone: 516-493-6089 =20= > *** > **** 500 Commack Road fax : 516-493-6091 =20= > **** > ***** Commack, NY 11725 =20= > ***** > ***************************************************************************= > ***** > =20 > > > > > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison emails: ennis@ssax.com ennis@starnetusa.com