Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Best way to index this query.

Status
Not open for further replies.
altendew

altendew

Programmer
Mar 29, 2005
154
US
Hi I currently have this query.

Code: 
SELECT sum( worth ),sum( burst ) 
FROM 3280266_spends
WHERE donation = '0'

This sometimes runs through 70,000 rows.. what would be the best way to index this?
 
Sort by date Sort by votes
Here is the solution

Code: 
ALTER TABLE 324632_spends ADD INDEX ( `donation` , `worth` , `burst` )
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
Looking for suggestions on how to do this
Replies
4
Views
382
Chris Miller
Chris Miller
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
518
EdLentz
EdLentz
E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
229
EdZzy
E
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
402
EdLentz
EdLentz
waubain
  • Locked
  • Question
Reset cumulative sum to zero on every year
Replies
8
Views
607
waubain
waubain

Part and Inventory Search

Sponsor

Back
Top