Yann GAUTHERON [EMAIL PROTECTED] wrote:
ID_LOGIN is an integer
Can anyone say me if this :
WHERE index1=ID_LOGIN OR index2=ID_LOGIN
must be slower than those 2 queries :
WHERE index1=ID_LOGIN
WHERE index2=ID_LOGIN
for a 20 000 rows table ?
You can rewrite the first query with
Hi,
ID_LOGIN is an integer
Can anyone say me if this :
WHERE index1=ID_LOGIN OR index2=ID_LOGIN
must be slower than those 2 queries :
WHERE index1=ID_LOGIN
WHERE index2=ID_LOGIN
for a 20 000 rows table ?
Thanks for reading.
Abalam
--
MySQL General Mailing List
For list archives: