Re: optimizing query with multiple aggregates

On Wed, Oct 21, 2009 at 6:51 PM, Doug Cole <dougcole(at)gmail(dot)com> wrote:

>
> repeated across many different x,y values and fields to build out several
> histograms of the data. The main culprit appears to be the CASE statement,
> but I'm not sure what to use instead. I'm sure other people have had
> similar queries and I was wondering what methods they used to build out data
> like this?
>

Use group by with an appropriate division/rounding to create the appropriate
buckets, if they're all the same size.

select round(field/100) as bucket, count(*) as cnt from foo group by
round(field/100);

--
- David T. Wilson
david(dot)t(dot)wilson(at)gmail(dot)com