+----+-------------+-----------+------+-----------------+---------+---------+-------+------+----------------------------------------------+
| id | select_type | table     | type | possible_keys   | key     | key_len | ref   | rows | Extra                                        |
+----+-------------+-----------+------+-----------------+---------+---------+-------+------+----------------------------------------------+
|  1 | SIMPLE      | data | ref  | uidtime,idx_uid | idx_uid |       4 | const |    1 | Using where; Using temporary; Using filesort |
+----+-------------+-----------+------+-----------------+---------+---------+-------+------+----------------------------------------------+

 CREATE TABLE `data` (
  `id` int(255) unsigned NOT NULL auto_increment,
  `uid` int(255) unsigned NOT NULL default '0',
  `ip` varchar(16) NOT NULL default '',
  `DAY` int(2) unsigned NOT NULL default '0',
  `MONTH` int(2) unsigned NOT NULL default '0',
  `year` int(4) unsigned NOT NULL default '0',
  `bytes` bigint(255) unsigned NOT NULL default '0',
  `bytes_local` bigint(20) unsigned NOT NULL default '0',
  `timestamp` int(255) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `uidtime` (`uid`,`timestamp`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=300000000 |