官网示例 amazon_reviews 增加索引字段查询没效果,也没有走索引是啥原因啊

Viewed 16

80e869d93ae07b1f39c7af9b1a2944d.png
查询:SELECT
product_id,
any(product_title),
AVG(star_rating) AS rating,
COUNT() AS count
FROM
amazon_reviews
WHERE
review_body LIKE '%is super awesome%'
GROUP BY
product_id
ORDER BY
count DESC,
rating DESC,
product_id
LIMIT 5;

Total: 4s435ms

索引也没有过滤到条数

1 Answers

【问题状态】跟进中
【问题处理】定位中,有进展会更新到论坛