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