BestHub
Sign in
Tag

JSON Index

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 3, 2021 · Databases

Understanding MySQL Functional (Expression) Indexes

The article explains MySQL functional (expression) indexes, how they are implemented via generated columns, demonstrates their creation and performance benefits for datetime and JSON fields, compares them with prefix indexes, and offers guidance for older MySQL versions.

DatabaseJSON IndexMySQL
0 likes · 12 min read
Understanding MySQL Functional (Expression) Indexes
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 23, 2019 · Databases

MySQL 8.0.17 Release Highlights: Cloning, JSON Multi‑Value Indexes, Optimizer Improvements, and More

MySQL 8.0.17 introduces server cloning via MySQL Shell, multi‑value indexes for JSON arrays, enhanced JSON schema validation, optimizer and Volcano iterator upgrades, new collations, replication and routing enhancements, plus numerous bug fixes and deprecations, all detailed in the official release notes.

CloningDatabaseJSON Index
0 likes · 8 min read
MySQL 8.0.17 Release Highlights: Cloning, JSON Multi‑Value Indexes, Optimizer Improvements, and More