Re: Can someone help explain this

2001-03-14 Thread Fred van Engen
On Tue, Mar 13, 2001 at 08:03:09PM -0800, Bob Silva wrote: > 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;

RE: Can someone help explain this

2001-03-13 Thread Don Read
On 14-Mar-01 Bob Silva wrote: > > mysql> explain SELECT usernum FROM client WHERE usernum=4158774796; > +-+ >| Comment | > +-+ >| Impossible WHERE n

Can someone help explain this

2001-03-13 Thread Bob Silva
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; ++--+---+--+-+--+--