Subject Re: need help on optimization
Author Michael Vilhelmsen
> Now, does one answer Yes or No to that question? :-))
>
> Yes, it will use an index and, if you have only an ascending index on
> MyDate, it will be worse than walking the set. Define a DESC index
on any
> column that you are likely to want to do a MAX() on, across a large
> set. Then the result will be instantaneous. Apply a similar index
> strategy to any columns on which you are going to do a GROUP BY DESC
or an
> ORDER BY DESC) on a large set.
>


Thank you.

What I thought.
Just wanted to be assurred.

Michael