Subject | But min and max are slow even with indexes |
---|---|
Author | Mark Patterson |
Post date | 2002-08-09T04:56:54Z |
Hi,
This query was less impressive:
select
min(start_time),
max(start_time)
from sawmembersarchived
The first run was 41 seconds, then it came down to about 4 seconds. That's not
instantaneous like the condition. Is there a way to speed this up? Or do the
indexes simply not address this sort of thing?
I would have thought that if they helped with the > and < operators, getting the
min and max would have been easy. Cananyone enlighten me?
Regards,
Mark
This query was less impressive:
select
min(start_time),
max(start_time)
from sawmembersarchived
The first run was 41 seconds, then it came down to about 4 seconds. That's not
instantaneous like the condition. Is there a way to speed this up? Or do the
indexes simply not address this sort of thing?
I would have thought that if they helped with the > and < operators, getting the
min and max would have been easy. Cananyone enlighten me?
Regards,
Mark