Hope this isnt a dupe post...I mailed before confirmation was received so I
think my post died.
Here is the issue I run the query below and it takes forever ( 1+ minutes ).
It uses 2 keys (one unique) in the where clause but still does a full table
scan.
mysql> SELECT usernum FROM client WHERE u
Heres the query Im trying to run: takes about 2 minutes...both userid and usernum
columns have indexes...usernum is unique. Show keys follows.
mysql> explain SELECT usernum FROM client WHERE userid='Salty3' OR usernum =
4158774796;
++--+---+--+-+--+--
