Trigram Indexes Video Demonstration | Full Text Search Alternative

In this video demonstration you'll learn how to use trigram indexes as an alternative to full text search. The trigram approach performs very well for shorter text fields you might find in these kinds of use cases:

• Looking for something which may or may not be hyphenated
• Transliterated names of people, places, etc.
• Users make typos, either the users of the app or even those entering the data the app relies on.
• Spelling variations, such as in names; e.g. “Megan”, “Meaghan”, “Meagan”.

Video Chapters:
00:00 Introduction
00:18 What are Trigram Indexes?
00:28 When to use trigram indexes
00:40 Trigram Indexes demo
01:22 how to add a trigram index to a table

Other Text Search Content:

#CockroachDB #DistributedSQL