Subject Re: last record from a table
Author Sergio
--- 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.

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

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...