; To: [EMAIL 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 s
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 a
Hi,
I'm doing a query on the following table:
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-+---+
| time_utc | int(11) | | PRI | 0 | |
| prefix | varchar
