Talk about utilizing trigram indexing to make all queries more efficient

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.

Please authenticate to join the conversation.

Upvoters
Status

Completed

Board

💡 Feature Suggestions

Date

11 months ago

Author

Cameron Kolick

Subscribe to post

Get notified by email when there are changes.