Re: How to select the <= date row?

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_at_centrum.is        http://www.strengur.is/~frantz/pow4gl.html