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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

A table (Table1) with the relevant indices (e.g.
Field1Idx, Field2Idx) exists. Running a query like:
Select * from table1 where Field1Idx Like 'Value%'
returns result in expected timing scale, so does the
query:
Select * from table1 where Field2Idx Like 'Value%'

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%')

We have followed everything by the book, the table
includes another index on (Field1, Field2), running
Explain command on the last query details that it uses
the index (Field1, Field2), it's just too slow
(minutes we are talking about).

Anything we have not done for this delay to occur?
please enlighten.

regards

        
        
                
___________________________________________________________
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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]