Re: Index question

From: "Farmer, Byrd G - CFC" <Farmer.Byrd@cfwy.com> > >I have one table that has its indexes in a separate dbspace. I cannot find >anywhere in the documentation that says I can allocate extents to an index. >Does anyone know if there is a reason as to why I cannot? 7.24UC3. I do. Yes there is. It auotmatically calculates extent sizes based on the ratio (index rowsize/table+index rowsize) * table extent [or next extent] size. Something like that, anyway. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com