SUM in SELECT Syntax.. any way to optimize

[altendew]

Hi I currently have this query..

SELECT sum( burst ) AS sum, sum( worth ) AS sum2
FROM 3279655_spends
WHERE donation = '0'

It will run for 14-15 seconds at a time.

I am running MySQL 4.1

Is there any way to make this query not go so slow.

 

[Kozusnik]

Index the table by "donation".

Mark

 

[altendew]

I have it indexed as donation,id.. does having the id also ammended to it.. make it slower?

 

[altendew]

I had the index set to JUST donation before.. and it never relly add a problem. Then I added the row id.. and the problem started.

I dont understand why adding 1 column to an index would make it slower?