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 index fail?

Why does this SQL JSON index fail in production. The SQL code stores JSON as text and queries with LIKE, so indexes are never used. In SQL services this becomes a performance trap.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqljson #sqlindex #sqlquery #sqloptimization

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