kaostika

SQL Speed

Discussion created by kaostika on Mar 20, 2012
Latest reply on Mar 20, 2012 by kaostika

Hi,

 

I am running a SQL query against 350k records in a contacts table. Standard info. Name, email, tel#

 

SELECT IDContacts ,firstname,lastname

FROM Contacts

WHERE (lower(FirstName)) LIKE Lower('mark')

OR (lower(LastName)) LIKE Lower('mark')

ORDER BY LastName

 

It take about 5-8 second to run.

 

Is there a way to adjust the syntax to make it faster.

 

I tried to use an inner join and it was a bit faster. running this on 50k records take 1 sec.

 

Oreste

Outcomes