I am running a SQL query against 350k records in a contacts table. Standard info. Name, email, tel#
SELECT IDContacts ,firstname,lastname
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.