📣

TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

Get Started

Overview

Quick Start

Guides

Connect
Manage Resources
Data Integration
Load Data
Unload Data
Multimodal Data Analytics
Performance Tuning
Security & Reliability
Management

Troubleshooting

Tutorials

Ingest & Stream Data
Migrate Data

Reference

SQL Reference
General Reference

Support Services

Ngram Index

This page provides a comprehensive overview of Ngram index operations in TiDB Cloud Lake, 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 TiDB Cloud Lake enable efficient substring and pattern matching searches within text data, improving performance for LIKE and similar operations.

Ngram Index

Ngram Index Management

Was this page helpful?