In the last episode (Apr 04), Dan Rossi said:
> Create a compound index on either (time, source_ip) or (source_ip,
> time). Mysql cannot use two indexes on one table.
>
> woah what are you saying here , that it cant have multiple indexes
> within a table ?
You can; MySQL will only use one per ta
[EMAIL PROTECTED]
Subject: Re: MySQL index fun
In the last episode (Apr 03), Steve Phillips said:
> 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 <
In the last episode (Apr 03), Steve Phillips said:
> 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)
>
Hey People :-)
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 a
