RE: HELP!!! Can select from tables ordered by not indexed field
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4169A.C7B062FF
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Nevermind... just found out our logical logs were full.
> _____________________________________________=20
> From: Phillips, Rob =20
> Sent: Tuesday, March 30, 2004 3:22 PM
> To: informix-list@iiug.org
> Subject: HELP!!! Can select from tables ordered by not indexed
> field
>=20
> A few minutes ago our informix box quit selecting from tables when you
> order by a non indexed field.
>=20
> All plain selects work fine. All selects when ordering by an indexed
> field work fine. Only when I select * form table order by non-indexed
> field do I have a problem. The query just runs and runs and never
> returns anything or an error. This table for example only has 10 rows
> in it.
------_=_NextPart_001_01C4169A.C7B062FF
Content-Type: text/html;
charset="US-ASCII"
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=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.6944.0">
<TITLE>RE: HELP!!! Can select from tables ordered by not indexed =
field</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Nevermind… just =
found out our logical logs were full.</FONT>
</P>
<P><FONT SIZE=3D1 =
FACE=3D"Tahoma">_____________________________________________ </FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Tahoma">From: </FONT></B> <FONT =
SIZE=3D1 FACE=3D"Tahoma">Phillips, Rob </FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Tahoma">Sent: </FONT></B> <FONT =
SIZE=3D1 FACE=3D"Tahoma">Tuesday, March 30, 2004 3:22 PM</FONT>
<BR><B><FONT SIZE=3D1 =
FACE=3D"Tahoma">To: </FONT></B> <FONT SIZE=3D1 =
FACE=3D"Tahoma">informix-list@iiug.org</FONT>
<BR><B><FONT SIZE=3D1 =
FACE=3D"Tahoma">Subject: </FONT>=
</B> <FONT SIZE=3D1 FACE=3D"Tahoma">HELP!!! Can select from tables =
ordered by not indexed field</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">A few minutes ago our informix box quit =
selecting from tables when you order by a non indexed field.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">All plain selects work fine. All =
selects when ordering by an indexed field work fine. Only when I =
select * form table order by non-indexed field do I have a =problem. The query just runs and runs and never returns anything =
or an error. This table for example only has 10 rows in =
it.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C4169A.C7B062FF--
sending to informix-list