I have a data table in mysql and this table have a column type json. So I have run and compare 2 query:
Select * From table
Select count(*) From table Group By JSON_EXTRACT(info, “$.id”)
I noticed that the first query running slower than the second.
I have thought that the second query has to be slower than the first.
Can you explain this? Thank you!
I am trying to understand how the second query running and why the second faster than the first