Subject | Re: need help on optimization |
---|---|
Author | Michael Vilhelmsen |
Post date | 2005-04-25T09:24:55Z |
> 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.
Michael