Group by SQL performance

Database
Kks
N/A

Group by SQL performance

I have many aggregate queries using group by 15 columns

Could any body suggest how to tune the queries in such cases

e.g.

Select
sum (c1)
Sum(c2)
---

from abcd

group by 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15

1 REPLY

Re: Group by SQL performance

Hi,
can u please try using agrregated index

Regds,
sachin