OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: Select Performance

From: A Z (xtcsukyahoo.co.uk)
Date: Fri Mar 19 2004 - 06:31:04 CST

Thanks, but this is not what we expected. This means
to change the SQL command in the application. Our
understanding from the manual and other relational DBs
is that, it's suffice for existence of an index on the
field in the criteria (where clause) to run at optimal
speed.

regards

 --- Harald Fuchs <hf118protecting.net> wrote: > In
article
>
<20040319120003.70609.qmailweb60303.mail.yahoo.com>,
> A Z <xtcsukyahoo.co.uk> writes:
>
> > The problem (very slow) occurs when the query is
> run
> > on combination of these fields:
> > Select * from table1 where (Field1Idx Like
> 'Value%' or
> > Field2Idx Like 'Value%')
>
> Try a UNION query:
>
> SELECT *
> FROM table1
> WHERE Field1Idx LIKE 'Value%'
> UNION
> SELECT *
> FROM table1
> WHERE Field2Idx LIKE 'Value%'
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/mysql?unsub=xtcsukyahoo.co.uk
>

        
        
                
___________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql