Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Optimize a LIKE '%text%' query RE: Optimize a LIKE '%text%' query

  • November 9, 2018 at 10:00 am

    #2012989

    ralu_k_17 - Friday, November 9, 2018 6:52 AM

    Hello!

    Is there a way of optimizing(/workaround) the performance of a LIKE '%text%' query, on a non-unique column (so, no full text index possible)?  Both wildcards are required.

    Thank you for any input!

    It depends... There is a method that works but it requires that you maintain an "N-grams" table of your values. 

    Check out the following two articles...
    http://www.sqlservercentral.com/articles/Tally+Table/142316/
    https://sqlperformance.com/2017/02/sql-indexes/seek-leading-wildcard-sql-server