I have a table for ip data that i need to index to suit the following query
SELECT time,source_ip,bytes FROM data.tb_ipdata_0403 WHERE (time > 1049108400 AND time < 1051786799) AND (source_ip > 3389268097 AND source_ip < 3389268099)
if i created an index on the time column and an index of the source_ip column would the query then use these indexes or would i need to change my query ?
(I was thinking of an index on source_ip and then dropping all entries for the customer ip range into a tmp table and doing the summing on that as the table should be a lot smaller)
-- Steve Phillips Professional Slacker
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
