|Subject||Re: need help on optimization|
> Now, does one answer Yes or No to that question? :-))on any
> 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
> column that you are likely to want to do a MAX() on, across a largeor an
> 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
> ORDER BY DESC) on a large set.Thank you.
What I thought.
Just wanted to be assurred.