4 Replies Latest reply on Mar 20, 2012 5:50 PM by kaostika

    SQL Speed




      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.