Skip to main content

Talk about utilizing trigram indexing to make all queries more efficient

Feature Suggestions

The challenge is that we are using searching in datatable queries using LOWER(CAST()) and that makes it so trigram indexes aren’t utilized. We cast because we cannot search using LIKE on an integer. We need to determine the correct way to make this happen.

Posted by Cameron Kolick ·
Status: Completed1 comment

Log in to comment and vote

Comments1

  • Cameron Kolick

    Team•

    Apr 14, 2025

    We have a way to do this, just isn’t done for all tables. We should do this for all new ones moving forward but existing tables should be fixed as performance issues arise.