Re: to many extents for indexes

Greetings, You can not directly specify the size of the index extent, but it is based of the extent size set for the table. How online calculates the index extent size is the following: index extent size = ( (keysize + 9) / rowsize) * extent size) Regards, At 01:20 PM 2/20/98 CST, Bill Ennis wrote: >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 > > David Summers Systems Engineer INFORMIX SOFTWARE Atlanta, GA Voice (770) 206-5348 Fax (770)395-2305