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

    SQL Speed

    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