All,

Any advice on speeding up group-by? I'm getting great performance before the 
group-by clause (on a fairly decent size data set) , but adding it slows things 
down horribly. Without the group-by clause, the query takes about a minute, and 
all cores are fully in use. With the group-by cores, the query takes far 
longer. The only difference in the EXPLAIN plans appears to be the addition of 
the group-by clause.  There are a lot of rows to be joined in the clause. Is 
there an equivalent to setQueryParallelism for this? Any things to try?

Thanks,
Mike

Reply via email to