Ngram Index
This page provides a comprehensive overview of Ngram index operations in Databend, organized by functionality for easy reference.
Ngram Index Management
| Command | Description |
|---|---|
| CREATE NGRAM INDEX | Creates a new Ngram index for efficient substring search |
| REFRESH NGRAM INDEX | Refreshes an Ngram index |
| DROP NGRAM INDEX | Removes an Ngram index |
note
Ngram indexes in Databend enable efficient substring and pattern matching searches within text data, improving performance for LIKE and similar operations.