[Fwd: Order By ROWID not responding on OWS]
Posted in 1997
This is a multi-part message in MIME format. --------------271C275A13A5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit -- ------------------------------------------------------------------------ Ing. Melvin Perez Cedano | Tel. (809) 686-5574 Technical Vicepresident | Fax. (809) 686-5467 CAM Informatica, S. A. | e-mail: cam@codetel.net.do INFORMIX Authorized Distributor | Santo Domingo, Dominican Republic. ------------------------------------------------------------------------ --------------271C275A13A5 Content-Type: message/rfc822 Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-ID: <3460FE35.3905@codetel.net.do> Date: Wed, 05 Nov 1997 19:16:05 -0400 From: "Ing. Melvin Perez Cedano" <cam@codetel.net.do> Reply-To: cam@codetel.net.do Organization: CAM Informatica, S. A. X-Mailer: Mozilla 3.0 (Win95; I) MIME-Version: 1.0 To: Informix Mailing List <nformix-list@rmy.emory.edu> Subject: Order By ROWID not responding on OWS Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all: I'm using INFORMIX-OnLine Workgroup Server 7.20.UC2 on a COMPAQ Proliant 800, 64 MB RAM, SCO OpenServer. In a non-fragmented table I'm doing an select statement with an ORDER BY ROWID and it sleeps forever. The same statement works fine on INFORMIX-SE on the same platform. What's going on with this? -- ------------------------------------------------------------------------ Ing. Melvin Perez Cedano | Tel. (809) 686-5574 Technical Vicepresident | Fax. (809) 686-5467 CAM Informatica, S. A. | e-mail: cam@codetel.net.do INFORMIX Authorized Distributor | Santo Domingo, Dominican Republic. ------------------------------------------------------------------------ --------------271C275A13A5--