Re: Q: order by uses temp file

Posted in 1998

Art S. Kagel — Thu, 08 Oct 1998 16:20:08 -0400 — source: Informix-list mailing list archive (1991-1998)

Carlson@WHSmith wrote: > > Art S. Kagel wrote: > > > > Mickey Mestel wrote: > > [SNIP] > > What about: > > select * from interest > where objid = 72359 and objtype = 2 > order by objid, objtype, level desc Sure John, come up with the simple and obvious solution when we're trying to be opaque and deep. Art S. Kagel