Aikesheng Open Source Community
Jul 12, 2021 · Databases
Using CRC32/MD5 Hashes and Prefix Indexes for Efficient Long String Indexing in MySQL
The article explains how to improve indexing of long string columns in MySQL by using generated columns with CRC32/MD5 hashes, functional indexes introduced in MySQL 8.0.13, and prefix indexes, providing code examples and performance considerations.
CRC32Function IndexGenerated Column
0 likes · 4 min read