--- Alexandre Benson Smith <iblist@...> wrote:

> I would go for:
> select first 1 MyDate from MyTable order by ID desc
> With a descending index on ID of course.

Thanks Alexandre! I tried both and your method seems to be better...

There's a slight difference in the statics.

mine:
Reads from disk to cache = 8
Fetches from cache = 18

yours:
Reads from disk to cache = 0
Fetches from cache = 9

With 1.7 million of records I coudn't notice the speed difference, but I will use your version anyway...