Subject But min and max are slow even with indexes
Author Mark Patterson
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