Working with 160M entries table

2004-09-23 Thread Ricardo Oliveira
Hi, I'm doing a query on the following table: +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | time_utc | int(11) | | PRI | 0 | | | prefix |

Re: Working with 160M entries table

2004-09-23 Thread Brent Baisley
I don't think indexes have anything to do with it, unless you have an index on the prefix field, in which case it might use it for the grouping. But regardless, you are selecting all 160M records (no index used) AND doing 160M calculations (no index used) and then grouping 160M records (maybe

RE: Working with 160M entries table

2004-09-23 Thread Andy Eastham
PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Working with 160M entries table I don't think indexes have anything to do with it, unless you have an index on the prefix field, in which case it might use it for the grouping. But regardless, you are selecting all 160M records (no index used