PrecisionSQLMar 6

How to Stop JSON Queries From Ignoring Indexes

JSON_EXTRACT blocks indexes unless you use generated columns.

#mysql #json #generatedcolumns #howto #index #performance

https://www.youtube.com/watch?v=tjyBrNal7WI

How to Stop JSON Queries From Ignoring Indexes #howto

YouTube
Hacker NewsDec 12

SQLite JSON at Full Index Speed Using Generated Columns

https://www.dbpro.app/blog/sqlite-json-virtual-columns-indexing

#HackerNews #SQLite #JSON #GeneratedColumns #Indexing #DatabasePerformance

SQLite JSON Superpower: Virtual Columns + Indexing - DB Pro Blog

One of the coolest patterns in SQLite—store raw JSON documents, create virtual generated columns using json_extract, add indexes, and query JSON at full B-tree index speed.