Subject | Not using index for MAX |
---|---|
Author | Erick Sasse |
Post date | 2007-10-26T19:58:34Z |
If I have a integer PK and do a "SELECT MAX(MY_PK_FIELD) FROM MYTABLE"
it doesn't use the index to find the max value, why?
Thanks.
--
Erick Sasse
it doesn't use the index to find the max value, why?
Thanks.
--
Erick Sasse