How to speed up slow query from OR

2002-07-31 Thread James MacLean
Hi Folks, Have only known enough SQL to do what we needed. Today on mysql-3.23.51 we found out that : select something from table where index1 = 'value' or index2 = 'value'; Runs considerably slower than: select something from table where index1 = 'value'; or select something from table wher

Re: How to speed up slow query from OR

2002-08-01 Thread James MacLean
On Thu, 1 Aug 2002, Ralf Narozny wrote: > Hello! > > James MacLean wrote: > > >Hi Folks, > >Have only known enough SQL to do what we needed. > >Today on mysql-3.23.51 we found out that : > >select something from table where index1 = 'value' or