1 "where OR" query with indexes or 2 queries

[Yann GAUTHERON]

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: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw