Re: 7 vs 9

--0__=09BBE5FEDFC727078f9e8a93df938690918c09BBE5FEDFC72707 Content-type: text/plain; charset=KOI8-R Content-transfer-encoding: base64 If the error indicates that you are running out of space, the difference between 7 and 9 is the type of index (attached/detached). An attached index requires much less space. Increase the amount of space available in the IDS 9 instance. Christine > The default behavior of CREATE INDEX in IDS 9 is to create a > detached index versus IDS 7 which creates an attached index. The > attached index requires less space. I believe the SQL Syntax > manual gives the algorithm for the calculation of the detached > index initial extent size. Thank You for response. Yes, I've read manuals. But how this refers to the problem mentioned? -- âÅÓÐÌÁÔÎÙÊ ÐÏÞÔÏ×ÙÊ ÑÝÉË ÐÒÅÄÏÓÔÁ×ÌÅÎ http://webmail.delfi.lv sending to informix-list --0__=09BBE5FEDFC727078f9e8a93df938690918c09BBE5FEDFC72707 Content-type: text/html; charset=KOI8-R Content-Disposition: inline Content-transfer-encoding: base64 <html><body> <p>If the error indicates that you are running out of space, the difference between 7 and 9 is the type of index (attached/detached). An attached index requires much less space. Increase the amount of space available in the IDS 9 instance.<br> <br> Christine <br> <br> <br> <br> <tt>&gt; The default behavior of CREATE INDEX in IDS 9 is to create a<br> &gt; detached index versus IDS 7 which creates an attached index. &nbsp;The<br> &gt; attached index requires less space. &nbsp;I believe the SQL Syntax<br> &gt; manual gives the algorithm for the calculation of the detached<br> &gt; index initial extent size.<br> Thank You for response. Yes, I've read manuals. But how this refers <br> to the problem mentioned?<br> <br> -- <br> âÅÓÐÌÁÔÎÙÊ ÐÏÞÔÏ×ÙÊ ÑÝÉË ÐÒÅÄÏÓÔÁ×ÌÅÎ </tt><tt><a href="http://webmail.delfi.lv">http://webmail.delfi.lv</a></tt><tt><br>; sending to informix-list<br> </tt> </body></html> --0__=09BBE5FEDFC727078f9e8a93df938690918c09BBE5FEDFC72707-- sending to informix-list

On Fri, 17 Dec 2004 09:26:20 -0600, Christine Normile <cnormile@us.ibm.com> wrote: > >--0__=09BBE5FEDFC727078f9e8a93df938690918c09BBE5FEDFC72707 >Content-type: text/plain; charset=KOI8-R >Content-transfer-encoding: base64 > > > > > > >If the error indicates that you are running out of space, the difference >between 7 and 9 is the type of index (attached/detached). An attached >index requires much less space. Increase the amount of space available in >the IDS 9 instance. > >Christine > > > >> The default behavior of CREATE INDEX in IDS 9 is to create a >> detached index versus IDS 7 which creates an attached index. The >> attached index requires less space. I believe the . . . snip . . . Must have missed something in the translation . . . JWC