Re: Large database

[KimSeong Loh]

select count(event_id) as c, field, field2,f ield3 from xyz group by count limit 10;

Index on count might help, or maybe it won't.

select count(event_id) as c, field, field2,f ield3 from xyz where field='value' group by count limit 10;

If you have a where like this, then index on (field,count) will be very helpful.