Folks,
Anybody know a keen shortcut for the following:
SELECT count(skip_date)
FROM (SELECT DISTINCT skip_date FROM weekend_list
WHERE ... ...) days_to_skip;
That's a double aggregate, and is bound to be dog-slow.
--
-Josh Berkus
Aglio Database Solutions
San Francisco