| Subject | Optimal function of DESC Index versus ASC Index ? |
|---|---|
| Author | Arno Brinkman |
| Post date | 2002-11-04T20:36:38Z |
Hi,
Could someone tell me when an DESC index has a performance against an ASC
index. I've done some tests and the conclusion till know is that they are
the same or ASC is much better.
The only things i can see is when a DESC index is used for MAX function and
ORDER BY.
Regards,
Arno
Could someone tell me when an DESC index has a performance against an ASC
index. I've done some tests and the conclusion till know is that they are
the same or ASC is much better.
The only things i can see is when a DESC index is used for MAX function and
ORDER BY.
Regards,
Arno