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