Why does this SQL JSON extract never use the index?

Why does this SQL JSON extract never use the index. The SQL code queries JSON with JSON_EXTRACT. In MySQL that cannot use a regular index. In SQL use a generated column with an index.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqljson #sqljsonextract #sqlindex #sq...

https://www.youtube.com/watch?v=7ybwR_o8Wh8

Why does this SQL JSON extract never use the index? #sqlperformance

YouTube