MySQL index fun

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]

optimal selects and indexes ?

t_ip_source_ip (time,dest_ip,source_ip), KEY idx_time (time) yet the explain still claims that no indexes are being consulted for my query, why would this be ? is there a better way to construct the select so it uses indexes ? or have i created my indexes incorrectly ? any help would be apprecia