On Thu, Oct 22, 2009 at 6:22 AM, Kenneth Marshall wrote:
> On Wed, Oct 21, 2009 at 03:51:25PM -0700, Doug Cole wrote:
>> I have a reporting query that is taking nearly all of it's time in aggregate
>> functions and I'm trying to figure out how to optimize it. The que
On Wed, Oct 21, 2009 at 5:39 PM, Merlin Moncure wrote:
>
> On Wed, Oct 21, 2009 at 6:51 PM, Doug Cole wrote:
> > I have a reporting query that is taking nearly all of it's time in aggregate
> > functions and I'm trying to figure out how to optimize it. The query t
I have a reporting query that is taking nearly all of it's time in aggregate
functions and I'm trying to figure out how to optimize it. The query takes
approximately 170ms when run with "select *", but when run with all the
aggregate functions the query takes 18 seconds. The slowness comes from o
