Index question

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF886C.8C5BDFA0 Content-Type: text/plain; charset="iso-8859-1" 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. ------_=_NextPart_001_01BF886C.8C5BDFA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2651.75"> <TITLE>Index question</TITLE> </HEAD> <BODY> <P><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Courier New">I have one = table that has its indexes in a separate dbspace.&nbsp; I cannot find = anywhere in the documentation that says I can allocate extents to an = index.&nbsp; Does anyone know if there is a reason as to why I = cannot?&nbsp; 7.24UC3.</FONT></P> <BR> </BODY> </HTML> ------_=_NextPart_001_01BF886C.8C5BDFA0--

Farmer, Byrd G - CFC wrote: > 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. Please do not post MIME or HTML messages. Yes, I know. Informix sizes the extents of a detached index based on the ratio of the keylength to the rowsize times the extent and next sizes. This ensures that roughly the same number of keys are in an index extent as there are rows in a data extent. Many have asked for independent index extent sizing with the current scheme as the default. Please add your voice. -- Art S. Kagel & Family kagel@erols.com