Hi,
I want to find the earliest and latest times in the time column of my table internet_usage:
+--------------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+----------------------+------+-----+---------+-------+ | uid | int(10) unsigned | | MUL | 0 | | | time | timestamp(14) | YES | | NULL | | | ip | int(10) unsigned | | | 0 | | | urlid | int(10) unsigned | | | 0 | | | timetaken | smallint(5) unsigned | YES | | 0 | | | cs_size | int(10) unsigned | YES | | 0 | | | sc_size | int(10) unsigned | YES | | 0 | | | method_ID | tinyint(3) unsigned | | | 0 | | | action_ID | tinyint(3) unsigned | | | 0 | | | virus_ID | tinyint(3) unsigned | | | 0 | | | useragent_ID | smallint(5) unsigned | | | 0 | | +--------------+----------------------+------+-----+---------+-------+
So far there are 324936160 rows. If I do :
SELECT MIN(time) as earliest, MAX(time) as latest from internet_usage;
I can see the query is going to run for a long time. Do I have to create an index on time to speed this up or is there another way of doing it?
Thanks for any help.
JS.
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
