Re: How to select the <= date row?

Posted in 1996

John H. Frantz — Mon, 10 Jun 1996 14:21:15 +0100 — source: Informix-list mailing list archive (1991-1998)

Stefan Mahs wrote: > > .... > 2) Selecting the max(specified_date) where event_date <= specified_date > works fine, but it will take a couple of days to wade through 40 > million rows. > .... A couple of days?? What are you using, Oracle? :) Seriously, though, I assume you have an index that can be used in the query, i.e. one with a reverse ordered specified_date. ---------------------------------------------------------------------- John H. Frantz Power-4gl: Extending Informix-4gl frantz@centrum.is http://www.strengur.is/~frantz/pow4gl.html